topic Re: $Field question in QlikView

$Field question

mikecrengland — Wed, 14 Aug 2013 15:26:05 GMT

Hello All -

I had the bright idea of creating two list boxes as an easy way to browse through the data of new dashboard projects, but I can't get it to work.

I create the first list box with $Field and the second with an expression: =GetFieldSelections([$Field]). My thought was that I could cycle through the different fields to quickly see the values of the different fields as I was experimenting with new objects. Unfortunately, it didn't work. The second list box shows the name of the field selected in the first, but not the values of that field.

Should I be able to do this and I just messed up the expression? Or am I barking up the wrong tree?

Thanks!

Re: $Field question

swuehl — Wed, 14 Aug 2013 15:29:32 GMT

Try using this as field expression in your list box:

=$(=GetFieldSelections( $Field ))

Re: $Field question

mikecrengland — Wed, 14 Aug 2013 18:53:34 GMT

Perfect! Thank you!

Re: $Field question

jacekvsp — Wed, 04 Dec 2013 22:18:50 GMT

The expression from swuehl will only work with fields named without spaces. If you have fields with space in the name use:

='$(=GetFieldSelections( $Field ))'

Re: $Field question

stevedark — Thu, 05 Dec 2013 00:11:42 GMT

Hi Mike,

I have built a data profiler that I now use on the majority of client sites that I work on. This uses the max possible $Field - rather than relying on one being selected.

You can download my profiler from QlikCommunity here:

http://community.qlik.com/docs/DOC-5161

You will also find a link to a blog post there which describes how the profiler has been built.

Hope this is of interest to you.

Steve

Re: $Field question

mikecrengland — Thu, 05 Dec 2013 14:54:02 GMT

Thanks Steve!