topic Re: Need percenatge in QlikView

Need percenatge

soniasweety — Sat, 16 Nov 2024 17:46:51 GMT

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 %

Re: Need percenatge

MayilVahanan — Wed, 25 Nov 2020 08:02:13 GMT

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)

Re: Need percenatge

Vegar — Wed, 25 Nov 2020 08:06:08 GMT

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

Re: Need percenatge

Vegar — Wed, 25 Nov 2020 08:10:18 GMT

Added an adjusted QVW below.

Re: Need percenatge

soniasweety — Wed, 25 Nov 2020 08:21:23 GMT

Thanks Mayil. but distinct gave me wrong result.

Re: Need percenatge

soniasweety — Wed, 25 Nov 2020 08:22:20 GMT

Thanks @Vegar it worked.