topic Re: GetFieldSelections in QlikView in QlikView

GetFieldSelections in QlikView

diwakarnahata — Wed, 05 Nov 2014 07:50:53 GMT

Hi All,

The GetFieldSelections(field1) function gives the list of values selected in the field1, but is there any function which gives the list of values associated (in white)?

For e.g. If I select a value in Country field, can I get the list of Cities associated with that country using any function?

The GetPossibleCount() function gives the count of values associated but not values.

Thanks,

Diwakar

Re: GetFieldSelections in QlikView

alexandros17 — Wed, 05 Nov 2014 08:02:37 GMT

You can do:

concat({$ <field1={'$(=getfieldselection(field1))'}>} city)

let me know

Re: GetFieldSelections in QlikView

tresB — Wed, 05 Nov 2014 08:08:53 GMT

Or, simply:

Concat( Distinct City, ',')

Re: GetFieldSelections in QlikView

diwakarnahata — Wed, 05 Nov 2014 08:11:34 GMT

Perfect!!! Thanks a ton..