ListBox Variables

[#1]

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.

[MK_QSL]

=CONCAT({1}DISTINCT  Years,';')

[maxgro]

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

[ashfaq_haseeb]

Hi,

Check this

Regards

ASHFAQ

[Gabriel]

Hi,

This expression should work

=Concat(distinct YearFieldName,';')

Best Regards,

Gabriel