topic Re: using a trigger to match a value in QlikView

using a trigger to match a value

Thu, 16 Feb 2012 07:23:30 GMT

Hi, I am using a trigger to select the latest month value viz. Jan-12.

Actions - Select in Field

Currently this value is hardcoded in the 'Search String' section.

I tried putting this expression "=month(date(addmonths(today(),-1)))" so that the value changes with every month but it is not working.

The selection trigger doesn't seem to work.

Any suggestions please.

Thank you

using a trigger to match a value

CELAMBARASAN — Thu, 16 Feb 2012 07:32:28 GMT

Hi,

It will work If you have month field and the expression should not be enclosed in double qoutes.

Expression will be =month(addmonths(today(),-1))

Hope it helps

Celambarasan

using a trigger to match a value

vijay_iitkgp — Thu, 16 Feb 2012 07:33:21 GMT

Hi,

Please do not put expressions in Quote. It will work without quote.

using a trigger to match a value

Thu, 16 Feb 2012 08:19:17 GMT

Hi Celambarasan,

It still doesn't work.

I have the following values in the table:

Dec-11

Jan-12

Feb-12 etc.

In the search string, if i put Jan-12, selection works but when i use an expression like =month(date(addmonths(today(),-1))) it doesn't work.

BTW, this expression returns only the month name viz. Jan or Dec or Feb.

using a trigger to match a value

vijay_iitkgp — Thu, 16 Feb 2012 08:22:20 GMT

Hi ,

Use =Month(addmonths(Today(),-1))&'-'&Right(Year(Today(),2))

using a trigger to match a value

Thu, 16 Feb 2012 08:26:30 GMT

Hi Celambarasan, It still doesn't work.

I have the following values in the table:

Dec-11

Jan-12

Feb-12 etc.

In the search string, if i put Jan-12, selection works but when i use an expression like =month(date(addmonths(today(),-1))) it doesn't work.

BTW, this expression returns only the month name viz. Jan or Dec or Feb.

using a trigger to match a value

CELAMBARASAN — Thu, 16 Feb 2012 08:34:53 GMT

Hi,

try with this expression

=month(addmonths(today(),-1))&'-'&Date(addmonths(today(),-1),'YY')

Hope it helps

Celambarasan

Re: using a trigger to match a value

Thu, 16 Feb 2012 10:25:37 GMT

Thanks Celambarasan,

I have used the foll. expression. =Date(monthStart(date(addmonths(today(),-1))), 'MMM-YY')

Re: using a trigger to match a value

CELAMBARASAN — Thu, 16 Feb 2012 10:29:34 GMT

Hi,

It looks smarter way.

Celambarasan