topic Re: Make a multiple selection after one selection in QlikView

Make a multiple selection after one selection

Anonymous — Thu, 24 Apr 2014 11:50:00 GMT

Hi all,

I'm struggling with something that seems to be very easy.

What I want to do is that if the user Qlik on 201404 the selection for Live Period will be as shown below.

In other words: if the user selects a period, the period and all periods before should be selected.

Thanks for your help,

Kees den Boer

Re: Make a multiple selection after one selection

Thu, 24 Apr 2014 11:53:31 GMT

You could setup a document trigger on field change / variable change, the trigger applies a macro which selects <= the selected date

Re: Make a multiple selection after one selection

tresB — Thu, 24 Apr 2014 11:59:46 GMT

Use trigger:

='<='&[Live Period]

Like in attached sample

Re: Make a multiple selection after one selection

MK_QSL — Thu, 24 Apr 2014 12:31:14 GMT

You need to create a trigger for particular field.

Settings >> Document Properties >> Field Even Triggers >> Period

OnSelect >> AddAction >> Add >> Selection >> Select In Field

Field

Period

Search String

=IF(GetFieldSelections(Period),'<='&Period,'')

Now create a list box for Period...

Check enclosed file..

Hope this helps...

Re: Make a multiple selection after one selection

Anonymous — Thu, 24 Apr 2014 13:00:35 GMT

First of all I want to thank everyone for their replies.

The solution of Manish was exactly what I needed. There was only still a little issue. In your example you were using the field Period, but in my app it was [Live Period]. For some reason the last one didn't work, so I changed that name to [LivePeriod]. After that change the issue was fixed.

Thanks,

Kees

Re: Re: Make a multiple selection after one selection

MK_QSL — Thu, 24 Apr 2014 13:05:22 GMT

Live Period should work if you change Period to [Live Period]

Check enclosed file...

Re: Make a multiple selection after one selection

Anonymous — Thu, 24 Apr 2014 13:11:30 GMT

I did try that, but for some reason it didn't make the right selection. However it's ok that the space is not in the name.

Thanks again.