Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
melekolcayy
Contributor
Contributor

How to show target values ​​on qlik sense chart?

The bar chart report I designed has target, lower target and upper target values ​​listed for the data.How can I show the target values ​​on a yearly basis in a bar chart?

[KPITARGETS]:
load * inline [
DimID, keyfldgroup, KPIYEAR, keyfldkpi, TARGETNOM, TARGETMIN, TARGETMAX, ISINCREASE
1, "BSSG", 2024, "MTTR", 16, 18, 13, 0
2, "BSSG", 2024, "MTBF", 12, 9, 15, 1
3, "BSSG", 2024, "RESOLUTIONRATIO", 0.90, 0.80, 0.98, 1
4, "BSSG", 2024, "SATISFACTIONRATIO", 0.90, 0.80, 0.98, 1
5, "UGIZ", 2024, "MTTR", 16, 18, 13, 0
6, "UGIZ", 2024, "MTBF", 7, 5, 10, 1
7, "UGIZ", 2024, "RESOLUTIONRATIO", 0.90, 0.80, 0.98, 1
8, "UGIZ", 2024, "SATISFACTIONRATIO", 0.90, 0.80, 0.98, 1
];

 

Labels (1)
3 Replies
Clement15
Partner - Specialist
Partner - Specialist

Hello,
You can use the combo chart and use a second measure and select marker.

sk88024
Creator
Creator

May be something like this can help - 

Use the Add-ons option in Combo chart and check out the reference lines from screencap. I think same can be done in Bar chart as well.  

sk88024_0-1743769812367.png

sk88024_1-1743770053212.png

 

Dana_Baldwin
Support
Support

Hi @melekolcayy 

Please note the forum you have posted to is for the Data Integration product Compose. To reach your target audience, please consider posting your question here: https://community.qlik.com/t5/Qlik-Sense/ct-p/qlik-sense

Thanks,

Dana