Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vix_humix
New Contributor

KPI value based on selection

Hi all

i have one table with 4 column: test, area, machine, type

how to set the expression of the KPI that show the percentage something like count(area or machine or type) *100/ count(test)?

Thanks.

4 Replies
vikasmahajan
Honored Contributor III

Re: KPI value based on selection

Share Dummy data

brunobertels
Valued Contributor

Re: KPI value based on selection

Hi

In a KPI Object or Text Object the mesures would be like this

for area :

Count({$}area)/Count({$}test) select in the format number panel %

and same expression for area and machine

hope it helps

Bruno

puttemans
Valued Contributor

Re: KPI value based on selection

Hi, all depends on what you need, so an example would be more practical.

You'd get a percentage this way :

= (count(if(machine = 'yourdefinition', 1, 0))/ count(test))*100

Beware that you need to define the last part well. You need to make sure you get the right figure. In order to do so, I typically create several text objects, in which I put the first and the last part separately and the formula. That way, checking is easier.

Regards,

Johan

vishalwaghole
Valued Contributor II

Re: KPI value based on selection

Can you please share dummy data.

Community Browser