Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

ListBox Variables

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.

4 Replies

Re: ListBox Variables

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

MVP
MVP

Re: ListBox Variables

in set analysis (from qlik online help)

1Represents 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

Re: ListBox Variables

Hi,

Check this

Regards

ASHFAQ

Gabriel
Valued Contributor II

Re: ListBox Variables

Hi,

This expression should work

=Concat(distinct YearFieldName,';')

Best Regards,

Gabriel

Community Browser