topic Re: Qlik Month over Month Change in App Development

Qlik Month over Month Change

Shivam22 — Wed, 15 Oct 2025 20:18:53 GMT

Hello All,

i have a data set

YearMonth Product Volume

2025-01 AAA 100

2025-01 BBB 200

2025-01 CCC 300

2025-02 AAA 50

2025-02 BBB 250

2025-02 CCC 300

2025-03 AAA 100

2025-03 BBB 200

2025-03 CCC 340

Can anyone please help me to understand, how can i add a month over month change column in above table?

for example, 2025-01 and product AAA its -50% and for Procut CCC its 0%

Thanks in Advance

Re: Qlik Month over Month Change

hanna_choi — Thu, 16 Oct 2025 00:34:01 GMT

Hello @Shivam22

How about using modify, which is a measure attribute?

Re: Qlik Month over Month Change

Amit_Prajapati — Thu, 16 Oct 2025 06:57:07 GMT

Hi @Shivam22 , As @hanna_choi mentioned earlier, you can easily calculate this using the existing Modify option, which is available under the Measure attribute.

This approach also allows you to compute the moving average seamlessly.

Re: Qlik Month over Month Change

Shivam22 — Thu, 16 Oct 2025 22:09:05 GMT

Thank you All,

can you please tell me how to actually show the %difference or %drop, using difference as modifier is just giving me numbers but not % difference.

Re: Qlik Month over Month Change

hanna_choi — Fri, 17 Oct 2025 04:02:33 GMT

Hi @Shivam22

You are right the percentage cannot be displayed with the modifier option.

We have to use Set Analysis.
I am sharing the Set Analysis that I applied.

******

(Sum(Volume) - sum(aggr(above(sum(Volume)), Product, YearMonth)))

/ sum(aggr(above(sum(Volume)), Product, YearMonth))

***********

This Set Analysis is specific to the table chart.

Best Regards.

Re: Qlik Month over Month Change

Shivam22 — Fri, 17 Oct 2025 15:24:15 GMT

Thanks, alot,

for my data set its working until month 4 and as soon as i select month 5 the results are wrong.

For example

Month Product Result (using the formual)

Jan 2025 A -

Feb 2025 A -10%

Mar 2025 A 5%

But as soon as i select April 2025

Month Product Result (using the formula)

Jan 2025 A 10%

Feb 2025 A -10%

Mar 2025 A 5%

April 2025 A -

It's happening to when i select Apr, July etc very random

Formula used -

(Sum(Volume) - sum(aggr(above(sum(Volume)), Product, YearMonth)))

/ sum(aggr(above(sum(Volume)), Product, YearMonth))

Can you please help me understand and help me fix the problem,

Thanka alot!

Re: Qlik Month over Month Change

Shivam22 — Sat, 18 Oct 2025 18:10:41 GMT

Hi All,

I created other table on load script with proper sorting on dates and that fixed problem!

Thanks alot