Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to have a listbox in my Variables
.
=CONCAT(DISTINCT Years,";")
But now only the selected years are shown. I want to show all Years not only the selected ones.
=CONCAT({1}DISTINCT Years,';')
in set analysis (from qlik online help)
1 | Represents the full set of all the records in the application. |
$ | Represents the records of the current selection. The set expression {$} is thus the equivalent of not stating a set expression |
=concat(distinct Years, ';') // only selected
=concat({$} distinct Years, ';') // only selected
=concat({1} distinct Years, ';') // all distinct Years in the application
Hi,
Check this
Regards
ASHFAQ
Hi,
This expression should work
=Concat(distinct YearFieldName,';')
Best Regards,
Gabriel