topic Trigger in QlikView

Trigger

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi all ,

in the script i have made date as MonthName(Date)

And after reloading the application wheni go to sheet property and set the trigger as on activate sheet ...and select the field as

Date and under field =Max(Date)

When i go on that sheet this willnot select the max month ...

If i dont convert the the MOnthaname(Date) and just load it as Date

And i set the Sheet Triiger on activating sheet for Field Date and =Max(Date ) this is working

But i want to convert this date into monthname at the script level and then set the trigger in activatibg for max month ......

How can we achive this ?

Thanks in Advance

techvarun — Wed, 06 Sep 2017 06:02:05 GMT

try

Max(MonthName(Date))

PunamWagh — Wed, 06 Sep 2017 06:17:57 GMT

Try this,

max(date(date#(MonthName,'MMM'),'MM'))

smilingjohn — Wed, 06 Sep 2017 06:20:07 GMT

Hi Varun this not working when i use ur sugestion

smilingjohn — Wed, 06 Sep 2017 06:27:45 GMT

This not working Punam

tresB — Wed, 06 Sep 2017 06:35:25 GMT

Try:

=MonthName(Max(Date))

PunamWagh — Wed, 06 Sep 2017 06:36:32 GMT

Your MonthName field should be in MMM Format..

To Convert Date into Month use Month Function i.e. month(Date) as MonthName at script level

its_anandrjs — Wed, 06 Sep 2017 06:45:27 GMT

Try to create your field like

=Date( MonthName(Date) )

=Date( MonthName(Max(Date)) )