topic Re: To set Trigger on MAX YEAR in QlikView

To set Trigger on MAX YEAR

abhaysingh — Wed, 16 Jul 2014 07:44:42 GMT

i have created Fiscal Year (e.g. 2011-2012, 2012-2013, 2013-2014,2014-2015) from Date

Year i have created from DATE is 2011,2012,2013,2014 ,

but when i am doing Max(Fiscal Year) it is giving me output 2014, but i need it should show 2014-2015 so that i can set a Trigger for max Year

tresB — Wed, 16 Jul 2014 07:54:11 GMT

It is better to use dual() for such cases in the script. Or, you can try something like:

=FirstSortedValue([Fiscal Year], -Date) as the search string for trigger.

abhaysingh — Wed, 16 Jul 2014 08:06:27 GMT

thanks for your feedback but i want to set trigger for max year

it is not allowing me set max function on =FirstSortedValue([Fiscal Year], -Date) , giving me error

er_mohit — Wed, 16 Jul 2014 08:07:47 GMT

try to use maxstring(Fiscal Year)

Wed, 16 Jul 2014 08:09:20 GMT

Hi Abhay,

You need to use group by for FirstSortedValue function ..

abhaysingh — Wed, 16 Jul 2014 08:22:18 GMT

thanks its working