Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik Gurus,
I have a Qlikview App which one of its Expressions is being calculated by a variable:
$(vG.Measure.ST.Accum.Rotation.Value.Consumption)
This variable is showing the Consumption of stock of the selected period.
Is it possible to calculate Consumption of last 12 months (of maximum selected date) using this variable by adding any Qlikview function in the expression?
Thanks in advance.
Regards,
Jordi
We can use this?
Sum({<$(vG.Measure.ST.Accum.Rotation.Value.Consumption), MonthField = {">=$(AddMonths(=Max(MonthField),-3)) <=$(=Max(MonthField))"}>}Sales)
Or
Sum({<MonthField = {">=$(AddMonths(=Max(MonthField),-3)) <=$(=Max(MonthField))"}>} $(vG.Measure.ST.Accum.Rotation.Value.Consumption))