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
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.
One more… I you have a lot of tables, add a list box for $Table
Thanks. This is an example of a couple of objects that can be copy and pasted into any QlikView document and be useful.
Thanks! This was a help.
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.
Good idea Debbie. You may want to experiment with using
concat([$Table],’, ‘)
to show all the tables the filed is in.
Thanks.. This is helpful…
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
This is another way to listboxes (in spanish):
http://qlikviewapuntes.blogspot.com.ar/2014/01/cuadros-de-lista-personalizados.html
regards