Using Year as Dimension

[Jertkh]

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.

[shivanisapkale]

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

[Jertkh]

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

[shivanisapkale]

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

[Jertkh]

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

[shivanisapkale]

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