Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dimension Limit for previous 12 months ( but should calculate leaving the last 2 months)
New trade Year ( Dimension
Current View starts from April but should start from Feb 2017 and should calculate 12 months backward from there.
Hi Chetan,
I'm afraid this is not how you'd use Dimension Limits - the calculation of dimension limits is based on the values of the first expression, not the dimension.
Instead, I'd recommend calculating a conditional flag "Last12MonthFlag" in your calendar and use Set Analysis to select last 12 months:
sum({<Last12MonthFlag = {1}>} Value)
cheers,
Oleg Troyansky
Upgrade your Qlik skills at the Masters Summit for Qlik - this October in Boston!
Hello Oleg,
I am beginner with qlikview , so I am not sure if I understand you completely but how can I calculate for 12 months starting from Feb while I have data till April
Hi.
See the attached example.
Regards.
Would you share sample application