Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an excel table attached to this question.
Here is wat i want to achieve:
We want to calculatie (based on any selection) the total percentage of In Full. So depending on if the artikel is a piece (aantal) or KG. it should calculate de deliveryperformance.
The outcome of this set of data should be a KPI on total: 102,73%.
The files in Qlik sense are dimension and meassurements:
Dimensions are:
Datum, Deb.Nr, Deb.Naam, Art.Nr, Art.Naam, Aantal, Gewicht, RegAantal, NettoKg, Tijd.
Meassurements are:
Stuksartikel : IF(Stuksartikel = 'Ja','Ja','Nee')
#/KG Besteld: IF(Stuksartikel = 'Ja', Sum(Aantal), Sum(Gewicht))
#/KG Geleverd: IF(Stuksartikel = 'Ja', Sum(RegAantal),Sum([NettoKg]))
% #/KG Uitgeleverd: SUM(Distinct IF(Stuksartikel = 'Ja', RegAantal,NettoKg))/SUM(Distinct IF(Stuksartikel = 'Ja', Aantal,Gewicht))
Hope anyone can give me some idea’s how to make this KPI.
Hi,
Based on the calculation of your excel, I think the KPI expression should be :
=( Sum({<Stuksartikel = {"Ja"}>}RegAantal) + Sum({<Stuksartikel = {"Nee"}>}NettoKg) ) / ( Sum({<Stuksartikel = {"Ja"}>}Aantal) + Sum({<Stuksartikel = {"Nee"}>}Gewicht) )
Please try.
Aiolos
I don't know whether you can open my attachment, but it works in my desktop:
If you still can't get the correct answer, could you please share your example?
it's fine for me to open qlikview or qliksense, then I can check why it's not correct.
Thanks.
Aiolos Zhao
Hi Aiolos,
thanks for the solution. I had to change something in my app, now it works with your Formula. My only problem now is that when i select only the stuksartikel or only the kg artikel the outcome stays the same.
Do you have any idea?