Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi @Shivam22 , i dont know if is exactly what you need, but one option is using a Mekko chart instead a Bar chart:
Create your bar chart with those two dimension
Then try like this
where Volume is your measure
Hi @Shivam22
Try like this
**** expression
Only((Aggr((SUM(Volume) - above(SUM(Volume)))/above(SUM(Volume)) ,Product, YearMonth) ))