topic Re: MOnth in QlikView

MOnth

Fri, 13 Jul 2012 07:08:53 GMT

I m using below exp

vMonth and cMonth

Only({<[Month]={$(vMonth)}>}Visits)

Only({<[Month}={$(cMonth)}>}Visits)

to calulate visits for two month selected by user from input box.

now i want to do minus 1 from vMonth and cMonth in this exp i have used many

but not getting current result.

can any baody give right exp how to modify above exp so that it will select minus one month selected by user in input box

when user select june ,i want select may by using above two exp.

Fri, 13 Jul 2012 07:21:58 GMT

your Month value are Jan, Feb....? or 1,2,3?

try

month(makedate(2012,$(vMonth)-1,1))

Fri, 13 Jul 2012 19:41:52 GMT

may month is jan ,feb..........

Sat, 14 Jul 2012 18:43:23 GMT

month(makedate(2012,$(vMonth)-1,1))

it is not any working

is there any other solution to subtract month.

Jason_Michaelides — Sun, 15 Jul 2012 19:44:53 GMT

You could try:

Only({<[Month]={"=$(AddMonths(vMonth),-1)"}>}Visits)

Hope this helps,

Jason