Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sebastian_lueer
New Contributor

Revenue by month vs plan

hi Guys,

i am pretty new to qlik but like the software so far. I was able to create some apps already, but struggeling with something I already did in Excel but fail to convert into Qlik. Maybe someone can help

What I want, is to display revenue by moth and compare that to plan / target.

In the end it is supposed to look like this:

(dont mind the different colours, it would be okay for now if it would only compare sales vs plan).

I am sure I need to use the Combo Diagram, but I fail to sturckture my Data right I guess.

I tried to abstract how I have the data available at this point and attached it into the excel sheet below.

It would be possible for me to restructure the data, if it would help getting to where I want

Tabelle1 = revenue

Tabelle2 = plan

Thank you already for your help, much appreciated.