Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am new to Qlik Sense and would be glad if I can get some help.
I have a sample table as below and would like to output similar to the sample chart as shown.
Thank you.
Hi,
Take dimension and measure and use a bar chart and in barchart under it there is apperance use a stacked barchart.
Regards,
Shivani Sapkale
Hi Shivani,
Thanks for replying. Could you be more specific?
I tried using the Year as Dimension and and Sum(Category) as Measure but couldn't work.
Regards,
JerTKH
Hi,
Take Category as dimension and sum of all the rest columns
Sum(2019)
SUm(2020)
You will get a output like the attached image check the attached image.
Regards,
Shivani
Hi,
I would like the X-axis to be the Year and the bars to be stacked as the categories.
Thank you.
Kind regards,
JerTKH
Hello,
For this you have to use cross table
For example:
[Test]:
CrossTable(Year,Data,1)
Load * Inline
[Category,2019,2020,2021
A,1000,20000,30000
B,30000,40000,5000];
and in front end take 2 dimensions year and Category and measure as SUM(Data)
Find the attached output.
Regards,
Shivani Sapkale