topic Re: Current year previous 3 months in QlikView

Current year previous 3 months

Thu, 13 Sep 2012 09:03:13 GMT

Fin_Year	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2011	45000	44000	46000	45000	47000	48000	49000	40000	41000	42000	44000	45000

this is my data.

i want to show this when i select August 2011

Jun	Jul	Aug
48000	49000	40000

and when I select April this should come.

Feb	Mar	Apr
44000	46000	45000

rajni_batra — Thu, 13 Sep 2012 09:08:05 GMT

try month>= addmonths(month,2)

tresB — Thu, 13 Sep 2012 09:14:59 GMT

Have a look at the attachment. Hope this helps. (Courtsey: sparur)

Regards,

tresesco

Thu, 13 Sep 2012 09:27:29 GMT

you can also try this:

sum({<date = {'<=$(=MonthEnd(makedate(fin_year,month,1)))>=$(=addmonths(makedate(fin_year,month,1),-2))'}, month = >}field)

sivarajs — Thu, 13 Sep 2012 09:37:10 GMT

Try the attached sample

Thu, 13 Sep 2012 09:53:28 GMT

Sivaraj you sample will only work when your Months are numbers!! But in irfankhanirf case you have the Monthnames.

regards,

sivarajs — Thu, 13 Sep 2012 11:07:31 GMT

Check out this sample