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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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