Solved: Get All Values in a Field - Qlik Community

Report Inappropriate Content · ‎2013-05-21

Hi guys!

I'm new to QlikView and got a question here:

I have a field contain cities:

and I select two of them (New York and Melbourne😞

I know I can get selected values using GetFieldSelections() function.

But how to get all field values (including selected) so that it will return (Jakarta, New York, Melbourne, Madrid, Tokyo and Prague)?

Thanks in advance!

A

kumarnatarajan · ‎2013-05-21

Hi,

Try this

EX: =Concat(DISTINCT {1} Cities,',')

Sokkorn · ‎2013-05-21

Hi Adrian,

May be this one you looking for =Concat({1} Cities,',')

Regards,

Sokkorn

kumarnatarajan · ‎2013-05-21

Hi,

Try this

EX: =Concat(DISTINCT {1} Cities,',')

Report Inappropriate Content · ‎2013-05-21

Thank you Sokkorn and Kumar!

Yes I want to distinct the result too.

Get All Values in a Field