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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST 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