Discussion Board for collaboration related to QlikView App Development.
I want last two months of data in dimension
how to write calculation condition
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
Actually you have to add a Calculated Dimension, Try this:
I have date column and I want last two months in calculated dimension
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 as Last6Mos
WHERE Date >= monthstart(today(),-2);
If you use Monthstart you must subtract the number of days so it is not -2 but something like -60.