Dates

Anonymous — Thu, 19 Nov 2015 19:08:34 GMT

I have an trigger when document open where date is selected as max date , but I have few expressions in the chart as below as for the same date column (but checking previous date value) which are not working , can someone please suggest a solution.. the values are shown for clndr_dt for the max value only , do I need to have another column to calculate previous date?

please help

Attached the application

Thanks

Re: Dates

settu_periasamy — Thu, 17 Dec 2015 05:02:51 GMT

Hi,

You can try to use the below expression in your trigger

=Max({1}Date,2) => This will always give the 2nd Maximum value, if you want based on selection, just remove {1}

Or, if you want always the 2nd Maximum value, you can use the same expression in your variable too..

Check the Attachment.

topic Re: Dates in QlikView

Dates

Re: Dates