Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
];
Hello,
You can use the combo chart and use a second measure and select marker.
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.
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