Default selections in list boxes

[Anonymous]

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,

[karthickv]

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.

[Lech_Miszkiewicz]

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