GetFieldSelections in QlikView

[diwakarnahata]

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

[alexandros17]

You can do:

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

let me know

[tresesco · Accepted solution]

Or, simply:

Concat( Distinct City, ',')

[diwakarnahata]

Perfect!!! Thanks a ton..