Dimension Limit for previous 12 months ( but should calculate leaving the last 2 months)

[#1]

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.

[Oleg_Troyansky]

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!

[#3]

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

[spividori]

Hi.

See the attached example.

Regards.

[Anil_Babu_Samineni]

Would you share sample application