topic Re: KPI chart with percentage in QlikView

KPI chart with percentage

Olya — Sat, 16 Nov 2024 20:03:47 GMT

Hi all,

How can I make the KPI chart with two KPI's - the first one should be an absolute number and the second KPI should show this number in percentage. I have used the expression:

count([Opportunity Line Number])/count(total [Opportunity Line Number]) for the percentage formula

but it shows always 100%, even I do selections in the other charts.

Thanks

Re: KPI chart with percentage

sugathirajkumar — Wed, 18 Sep 2019 09:13:41 GMT

can you provide the sample data

Re: KPI chart with percentage

StarinieriG — Wed, 18 Sep 2019 09:42:49 GMT

It's correct that it is always 100 % because if you count a field (with selection or not) without set analysis for example, count total anyway.

Then those two expression are always the same.

Re: KPI chart with percentage

asinha1991 — Wed, 18 Sep 2019 12:15:53 GMT

total outside chart make no sense, maybe you want this?

count([Opportunity Line Number])/count({1}[Opportunity Line Number])

Re: KPI chart with percentage

Olya — Wed, 18 Sep 2019 12:58:36 GMT

thanks! What is what I needed 🙂