Make a multiple selection after one selection

[Anonymous]

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

[#2]

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

[tresesco]

Use trigger:

='<='&[Live Period]

Like in attached sample

[MK_QSL · Accepted solution]

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...

[Anonymous]

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

[MK_QSL]

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

Check enclosed file...

[Anonymous]

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.