Quick Tip for Exploring Your Data Model

I picked up a great tip from QlikCommunity to view field values in your data model:
http://community.qlikview.com/thread/89396

I refined it a bit and am finding it very useful.

1. Create a listbox for field “$Field”.
2. Create a Straight Table Chart with:
  a) Calculated Dimension:  =$(='[‘ & only([$Field]) & ‘]’)
  b) Expression:  =sum({1}1)

Select a $Field in the listbox and the field values and frequencies will appear in the chart. Very handy for exploring data values in your model.

-Rob

9 thoughts on “Quick Tip for Exploring Your Data Model”

  1. Thanks Rob! (it was me that couldn’t figure out the $-sign part to get it to work)

    A big part of my job is teaching analysts how to work the front end of QlikView. I’m not a developer, so any help I can get is much appreciated! If you are ever bored, feel charitable, and want to refine my other stuff, it would be much appreciated as well… I publish my tips at http://www.fortunecookiebi.com .

    Thanks again for the tip on this and on everything else you do here and in the qlikcommunity.

  2. Thanks. This is an example of a couple of objects that can be copy and pasted into any QlikView document and be useful.

  3. Very nice. I added this to my valiation tabs and I added an expression of maxstring([$Table]) to the list box so you can also see what table it is sourced from in the list box.

  4. Qlik View Online Training Call Us-001-309-200-3848 21st Century Software Solutions Online Training 21st Century providing Online training and support on All Technologies. If you are seeking training and support you can reach me on 91-9000444287. Online training by real time Experts. Call us 001-309-200-3848 for online training QlikView Online Training, Qlik View training, QlikView course contents, QlikView, Qlik View enquiry, Qlik View training institute india, Andhra Pradesh, Visakhapatnam, call us: +919000444287,dharani@21cssindia.com QlikView Online Training, Qlik View training, QlikView course contents, QlikView, Qlik View enquiry, Qlik View training institute india, Andhra Pradesh, Visakhapatnam, call us: +919000444287,dharani@21cssindia.com http://www.21cssindia.com/courses/qlik-view-online-training-139.html contact@21cssindia.com

Comments are closed.