topic Re: Dynamic Months in QlikView

Dynamic Months

Anonymous — Wed, 08 Nov 2017 10:09:59 GMT

I want last two months of data in dimension

how to write calculation condition

Re: Dynamic Months

Ralf_Heukäufer — Wed, 08 Nov 2017 10:16:46 GMT

Hello,

you can try

if((yourmonthvariable = month(today()) or yourmonthvariable = month(today()) -1) , yourmonthvariable)

But you must have select the actual year in filter for that

Re: Dynamic Months

Anonymous — Wed, 08 Nov 2017 10:18:33 GMT

Actually you have to add a Calculated Dimension, Try this:

aggr(only({<Date={">=date(monthstart(today(),-6))"}>} MonthYr),MonthYr)

Re: Dynamic Months

Anonymous — Wed, 08 Nov 2017 10:34:50 GMT

I have date column and I want last two months in calculated dimension

Re: Dynamic Months

Anonymous — Wed, 08 Nov 2017 10:45:19 GMT

Qlik dont work well creating calculated dimensions in Chart, so, use it just in an specific case. The best way is to create it on Script, for example:

LEFT JOIN (Calendar) LOAD

MonthYr,

MonthYr as Last6Mos

RESIDENT Calendar

WHERE Date >= monthstart(today(),-2);

Re: Dynamic Months

Ralf_Heukäufer — Wed, 08 Nov 2017 10:51:49 GMT

If you use Monthstart you must subtract the number of days so it is not -2 but something like -60.