Display the whole year per month in Combo Chart

[Qlik_Bio06]

Hi,

I would like to show the sales (CHF) 2020 per month in the chart. Jan-Dec

What do I have to do with the column "Created on" so that it can be handled more easily.

Thanks for the help.

[JordyWegman]

Hi,

There are multiple possibilities here.

1. Month( Date#( [Created on]  , 'DD.MM.YYYY' ) )
2. Year( Date#( [Created on]  , 'DD.MM.YYYY' ) ) & '-' &  Month( Date#( [Created on]  , 'DD.MM.YYYY' ) )

This first will give the month, but the second will do a combination with the year.

Jordy

Climber

[Qlik_Bio06]

Hi,

I'm a lot further now. Maybe you can help here.https://community.qlik.com/t5/New-to-Qlik-Sense/How-to-display-Order-volume-cumulative-current-month...