Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Calculate %

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-

 

Br

 

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

Re: Calculate %

try like this:

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

regards

tim

View solution in original post

2 Replies
Highlighted
Specialist II
Specialist II

Re: Calculate %

try like this:

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

regards

tim

View solution in original post

Highlighted
Creator III
Creator III

Re: Calculate %

Easy, haha. Just blind today 🙂 

Thanx Mate!!