Discussion Board for collaboration related to QlikView App Development.
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-
try like this:
='Utfall: ' & round (100-Count(if([Expression2] >=2, ([Expression2])))/count([Expression2])*100,0.01) & ' %'
View solution in original post
Easy, haha. Just blind today 🙂