topic Re: Expand ListBox if valu selected in QlikView

Expand ListBox if valu selected

Kunkulis — Sat, 16 Nov 2024 19:15:55 GMT

Hello,

I have a ListBox of Years from 2006 till 2020.

Now with an expression I have made it into this:

Now what I would like to achieve is, if you select 'Older' it doesn't select 2006-2015 years, but expands the list.
Doesn't really matter how, the main thing would be so it doesn't create cluster.

Re: Expand ListBox if valu selected

Kunkulis — Tue, 21 Jan 2020 12:32:52 GMT

Managed to find the solution.

Using "<Expression>" in fields and this was my statement

=if(Match([Year],'2020','2019','2018','2017','2016'), [Year],if(Match([Year],'2015','2014','2013'),'Older'&'/'& [Year]))

Select 'Show as TreeView' and its done

Re: Expand ListBox if valu selected

marcus_sommer — Tue, 21 Jan 2020 12:47:25 GMT

You may reach it with the use of several actions which query the selections and show/hide (probably with the help of some variables) multiple listboxes and de-select the values appropriate.

Like it already sounds I wouldn't go this way else I would probably use a cyclic dimension-group within the listbox. This may native fields from the datamodel or just calculated dimensions within the group. The important point is not to include a cluster of values like your created 'Older' else just those values which are intended. I think I would create 3 dimensions with 'Current Years', 'Older Years' and 'All Years'.

- Marcus