Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MVP
MVP

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

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.