Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Adding targets per sales rep

Good day,

 

I am trying to put monthly targets inside a graph.

This is the graph as is:

graph.png

 
 

Now I want to have a line that shows the target per Salesrep in reference to the numbers.

This is an excel of the data I want to put in visualisation:

 

reference.png

 

Any ideas would be welcome.

Kind Regards,

Dries

Labels (1)
2 Replies
Highlighted
MVP
MVP

IS it bar or combo chart? How exactly target like should look like?

Highlighted
Creator
Creator

Hello,

 

right now it's a normal bar graph,

but it should be a combochart.

 

Where we see the sales numbers combared over the months.

and above it a line that represents the targets.

 

So when i select a certain representative I can see per month if the target is met.

 

Thanks in advance.