Qlik Month over Month Change

[Shivam22]

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

[hanna_choi]

Hello @Shivam22 

How about using modify, which is a measure attribute?

[Amit_Prajapati]

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.

[Shivam22]

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.

[hanna_choi · Accepted solution]

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.

[Shivam22]

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!

[Shivam22]

Hi All,

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

Thanks alot