topic Re: Calculation MoM % for different measures in Pivot table in App Development

Calculation MoM % for different measures in Pivot table

sathishr — Wed, 07 Feb 2024 15:01:24 GMT

Hello All,

I want to achieve a view like below in Qlik Sense which is a replica of OBI.

I have created a Pivot table in Qlik with Stream & Service as Rows , Month as Column and calculated the Records, Volume and Duration as Measures. But MoM% calculation when i add it as a Measure using Column function to achieve , it gets split over the Month ( Column Dimension).

Could you please help me how i can achieve the similar view as in OBI.

In OBI it has been achieved by adding the MoM % as Calculated filed on the Month( Dimension).

Re: Calculation MoM % for different measures in Pivot table

Chanty4u — Wed, 07 Feb 2024 16:21:29 GMT

Try this

(Sum({<Month={$(=Max(Month)-1)}>}[Measure]) - Sum({<Month={$(=Max(Month))}>}[Measure])) / Sum({<Month={$(=Max(Month)-1)}>}[Measure])

Re: Calculation MoM % for different measures in Pivot table

sathishr — Wed, 07 Feb 2024 22:57:37 GMT

Thanks for your response Chanty4u... This formula can be used to calculate the Month over month value but it wouldn't solve the issue of Grouping for display as it is done in OBI.

With the formula you have given , I can achieve the below snippet? (which I have already managed by another away but not accepted by the user community :()

How do I manage to get a view like below please? Grouping of Measures like Files , Records, Value and under each Measure I want to display Current , Previous Month and Month over Month Variance %