Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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.
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