topic Re: ListBox Variables in QlikView

ListBox Variables

Mon, 26 Jan 2026 18:19:17 GMT

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 — Sat, 08 Nov 2014 00:48:14 GMT

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

maxgro — Sat, 08 Nov 2014 08:38:24 GMT

in set analysis (from qlik online help)

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 — Sun, 09 Nov 2014 07:13:52 GMT

Hi,

Check this

Regards

ASHFAQ

Gabriel — Tue, 11 Nov 2014 23:08:29 GMT

Hi,

This expression should work

=Concat(distinct YearFieldName,';')

Best Regards,

Gabriel