Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I've been using Qliksense for a while now and so far every issue I had i could solve by a blog post in this community, it is very helpful! Now however I came across something I can't figure out how to do this. I have millions of records in the following format:
Part ID | Fault code |
1 | F01 |
2 | F01 |
3 | F03 |
3 | F02 |
4 | |
5 | F03 |
5 | F02 |
5 | F01 |
6 | |
7 | |
8 | F03 |
8 | F02 |
9 | |
10 | F01 |
I want to show a KPI of the 'touch' on part level and show it in % of total produced parts. Which means I have to count the amount of Unique Part ID's with a fault code and divide it by the total amount of Unique Part ID's.
In this example it would be 6 parts with a fault code (some with multiple fault codes but this doesn't matter for the touch %) of 10 total parts giving 60% touch.
I hope someone can help me with this.
Thanks for your help.
Geert
Hi,
try like this,
=Count({<Faultcode={'*'}>}Distinct PartID)
/
Count(Distinct PartID)
May be this
Num(Count({<PartID={"=Len(Trim(MaxString(Faultcode))) > 0"}>} DISTINCT PartID)/Count(DISTINCT PartID),'#0 %')
Regards,
Antonio
Hi,
try like this,
=Count({<Faultcode={'*'}>}Distinct PartID)
/
Count(Distinct PartID)
Hi,
Both solutions worked, thanks a lot!
Geert