topic Re: % accuracy expression in QlikView

% accuracy expression

anonymous1 — Thu, 18 Jul 2019 08:23:53 GMT

hi,

i need to create a table that shows planned shipments of an item, actual shipments, and finally calculate the % accuracy.

im using the following expression to calculate the % accuracy:

=FABS(sum({<[PLANNED_OR_ACTUAL]={'PLANNED'}>}SHIPMENTS)-sum({<[PLANNED_OR_ACTUAL]={'ACTUAL'}>}SHIPMENT))
/sum({<[PLANNED_OR_ACTUAL]={'ACTUAL'}>}SHIPMENT)*100

(actual-planned)/actual * 100

but the output doesn't seem right, does anyone have a better idea of how i can calculate this?

TIA

Re: % accuracy expression

Frank_Hartmann — Thu, 18 Jul 2019 09:12:38 GMT

SHIPMENTS or SHIPMENT?

Re: % accuracy expression

anonymous1 — Thu, 18 Jul 2019 09:15:04 GMT

apologies, SHIPMENT is correct

Re: % accuracy expression

Brett_Bleess — Tue, 13 Aug 2019 13:54:51 GMT

Natasha, have a look at the following link, I think it may help to a degree. Feel free to search the Design Blog area for other posts to, there are hundreds out there with more examples etc. Hopefully this may help move you along a bit further.

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

Regards,
Brett