Trigger is not working

[manoranjan_d]

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]

Try this

=max({1}date)

[Anonymous]

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]

thabnks mahesh and avinash