topic Calculate % in QlikView

Calculate %

johnan — Sat, 16 Nov 2024 19:56:35 GMT

Hi, i have a text like this:

='Utfall: ' & round (Count(if([Antal fel] >=2, ([Package Number])))/count([Package Number])*100,0.01) & ' %'

It's give me 5,62% and i want to show 94,38 % instead of 5,62

Where can i put like 100-

zhadrakas — Tue, 08 Oct 2019 08:00:51 GMT

try like this:

='Utfall: ' & round (100-Count(if([Expression2] >=2, ([Expression2])))/count([Expression2])*100,0.01) & ' %'

regards

tim

johnan — Tue, 08 Oct 2019 08:02:35 GMT

Easy, haha. Just blind today 🙂

Thanx Mate!!