Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Shivam22
Contributor II
Contributor II

Bar Chart with month over month change in %

Hi All,

I have a data with table

YearMonth    Product      Volume

2025-01           AAA             100

2025-01           BBB             200

2025-01           CCC            300

2025-02          AAA               45

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 how can we create a stacked Bar chart on Qlik Cloud should month over month change % for each product 

Stack - YearMonth

Bars - Product

Measure - Count (Volume)

 

I can only show count but cannot show Month over Month difference for each Product to know if count is increased or decreased from previous month

 

Thanks in Advance

 

 

3 Replies
QFabian
MVP
MVP

Hi @Shivam22 , i dont know if is exactly what you need, but one option is using a Mekko chart instead a Bar chart:

QFabian_0-1760649249626.png

 

Greetings!! Fabián Quezada (QFabian)
did it work for you? give like and mark the solution as accepted.
robert_mika
Master III
Master III

Create your bar chart  with those two dimension

Then try like this

where Volume is your measure

( Volume - Above(Volume) ) / 
Above(Volume)
hanna_choi
Partner - Creator II
Partner - Creator II

Hi @Shivam22

 

Try like this

**** expression

 

Only((Aggr((SUM(Volume) - above(SUM(Volume)))/above(SUM(Volume)) ,Product, YearMonth) ))

hanna_choi_0-1760682871289.png