Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

Need percenatge

Hi @MayilVahanan 

 

@Vegar 


i want to show  the percentage of pass and fail .

for example : L1 users 10 members in that 4 pass and 6 fail.. so i want that pass percentage and fail %

Labels (3)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

Added an adjusted QVW below.

image.png

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

5 Replies
MayilVahanan

Hi @soniasweety 

Try like below

Dim: Level

Pass: Count({<Status={'Pass'}>}DISTINCT user) / Count(DISTINCT user)

Fail: Count({<Status={'Fail'}>}DISTINCT user) / Count(DISTINCT user)

 

Thanks & Regards,
Mayil Vahanan R
Vegar
MVP
MVP

Hi 

Vegar_0-1606291482839.png

Use an expression like this: 

Num(Count({<Status={'Fail'}>}Status)/count(Status), '0%') //Fail precentage

or this

Num(Count({<Status={'Pass'}>}Status)/count(Status), '0%') //Pass precentage

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Vegar
MVP
MVP

Added an adjusted QVW below.

image.png

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

soniasweety
Master
Master
Author

Thanks Mayil. but distinct gave me wrong result.

soniasweety
Master
Master
Author

Thanks @Vegar  it worked.