topic Re: Trigger is not working in QlikView

Trigger is not working

manoranjan_d — Mon, 07 Aug 2017 07:36:57 GMT

in the trigger i have given

1)clear all

and then

2)select in field

=max(date)

example max date is 7/Aug/2017

issue:

when i select multiple date in the list box example

1/Aug/2017

2/Aug/2017

3/Aug/2017

and saved the file.

if i open the file the trigger value of max date is 7/aug/2017 is not selected in the list box and its not working also.

its taking the selection of these three values of max date is 3/Aug/2017.

how to resolve this issue

avinashelite — Mon, 07 Aug 2017 07:38:31 GMT

Try this

=max({1}date)

Anonymous — Mon, 07 Aug 2017 07:57:56 GMT

Hello Manoranjan ,

When we select the multiple date fields . the max date will always be consider based on selection only in Qlikview .

1. Try Max({1}Date)

2. Add two triggers Document properties --> Triggers --> onopen .

one trigger for clear all for fields selection and one trigger for max(date).

Try this hope it helps for you

Thanks

Mahesh

manoranjan_d — Mon, 07 Aug 2017 08:18:06 GMT

thabnks mahesh and avinash