topic Re: Date Trigger in QlikView

Date Trigger

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

[Month of Expense] >= monthname(today()) and [Month of Expense] <= monthname(AddMonths(today() ,11))

How do I put the above in sheet trigger ?

Thanks much.

Sat, 12 Nov 2016 00:28:49 GMT

Go to Sheet Properties, place your expression to show/hide sheet in Conditional textbox

apthansh — Sat, 12 Nov 2016 00:34:09 GMT

Thank you.

But I meant how to writ that Script in condition ? I think it needs a different format.

Sat, 12 Nov 2016 00:47:46 GMT

Declare two variables and use them in expression

vMonthToday = monthname(today());
vMonthAddMonths = monthname(AddMonths(today() ,11));

if([Month of Expense] >= $(vMonthToday) and [Month of Expense] <= $(vMonthAddMonths))

apthansh — Mon, 14 Nov 2016 03:14:17 GMT

Thank you...but I want to put it in Trigger condition ..so I gave as below

Field : [Month of Expense]

Search String : = '>=' & $(vMonthToday) and '<=' & $(vMonthAddMonths)

Doesnt look like it is working...

Month of expense is in below format

Nov 2016

Thanks much