Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys!
I'm new to QlikView and got a question here:
I have a field contain cities:
Cities |
---|
Jakarta |
New York |
Melbourne |
Madrid |
Tokyo |
Prague |
and I select two of them (New York and Melbourne😞
Cities |
---|
Jakarta |
New York |
Melbourne |
Madrid |
Tokyo |
Prague |
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
Hi Adrian,
May be this one you looking for =Concat({1} Cities,',')
Regards,
Sokkorn
Hi,
Try this
EX: =Concat(DISTINCT {1} Cities,',')
Thank you Sokkorn and Kumar!
Yes I want to distinct the result too.