Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
anonymous1
New Contributor III

% accuracy expression

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

 

3 Replies
Frank_Hartmann
Honored Contributor II

Re: % accuracy expression

SHIPMENTS or SHIPMENT?

anonymous1
New Contributor III

Re: % accuracy expression

apologies, SHIPMENT is correct

Support
Support

Re: % accuracy expression

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

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.