topic Default selections in list boxes in QlikView

Default selections in list boxes

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have 2 fields Period Type and Period Key. When the user selects the period type, I would like to default the 'Period Key' selection to the first possible value in the list box.

Any suggestions please.

Thank you,

Re: Default selections in list boxes

karthickv — Sun, 12 Mar 2017 21:25:00 GMT

Hi Aishwarya,

Are you looking for the latest Period type to be selected ?

From the screenshots, I can see Period Type seems to be already sorted and it is in proper format.

The first value could be selected using a simple Max(PeriodType). Why is it not working ?

Regards,

Karthick V.

Re: Default selections in list boxes

Lech_Miszkiewicz — Mon, 13 Mar 2017 00:41:27 GMT

Hi,

Use a global qlikview trigger:

Settings--> DocumentSettings--> Triggers --> Field Triggers -> choose "PeriodType" field and assign trigger on "OnChange" or "On Select" (depending on your needs) AddAction: Select in field: Field Name and in trigger use a suggested by Karthick formula.

Click Ok and Test

See screenshots below:

regards

Lech