Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

Share Dummy data

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
brunobertels
Master
Master

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
Specialist
Specialist

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
Specialist II
Specialist II

Can you please share dummy data.