Adding percentage values issue in Qlik

laurenr171 — Wed, 05 Oct 2022 16:57:12 GMT

Hello,

I am trying to create a chart in Qlik that will display multiple data values within one category. However, Qlik wants to only sum, count, min/max, or average these values. What I need is to be able to see each percentage value by itself, and in a group. Please see the sample data below. What is the best way to produce a grouped bar chart (just for example) without requiring summing these percentage values? Thank you in advance!!!

Company	Country Code	Date	Stat 1	Stat 2	Stat 3	Stat 4	Stat 5
McDonalds	A	7/1/2022	0.99	0.66	0.55	0.44	0.33
McDonalds	B	7/1/2022	1	0	0	0.22
McDonalds	C	7/1/2022	0.88	0.02	0.17	0.03	0.89
McDonalds	D	7/1/2022	1	0.07	0.8	0.64
McDonalds	E	7/1/2022	0.93	0.11	0.15	0.23	0.05
McDonalds	A	8/1/2022	0.99	0.63	0.56	0.11	0.12
McDonalds	B	8/1/2022	1	0	0	0.14
McDonalds	C	8/1/2022	0.81	0.02	0.26	0.03	0.06
McDonalds	D	8/1/2022	1	0.79	0.82	0.64
McDonalds	E	8/1/2022	0.93	0.11	0.15	0.23	0.05
Burger King	A	7/1/2022	0.99	0.66	0.55	0.44	0.33
Burger King	B	7/1/2022	1	0	0	0.22
Burger King	C	7/1/2022	0.88	0.02	0.17	0.03	0.89
Burger King	D	7/1/2022	1	0.07	0.8	0.64
Burger King	E	7/1/2022	0.93	0.11	0.15	0.23	0.05
Burger King	A	8/1/2022	0.99	0.63	0.56	0.11	0.12
Burger King	B	8/1/2022	1	0	0	0.14
Burger King	C	8/1/2022	0.81	0.02	0.26	0.03	0.06
Burger King	D	8/1/2022	1	0.79	0.82	0.64
Burger King	E	8/1/2022	0.93	0.11	0.15	0.23	0.05

Re: Adding percentage values issue in Qlik

MendyS — Thu, 06 Oct 2022 06:26:01 GMT

Hi @laurenr171

I am not sure the complete got you, can you send please a couple of examples for the input and the output that you expect?
if I got you as I think, you need to use a function like Max/Maxstring on the key field, ( and if it does not exist you can create one) and enter that formula as a Measure.
let me know

topic Re: Adding percentage values issue in Qlik in App Development

Adding percentage values issue in Qlik

Re: Adding percentage values issue in Qlik