Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
in addition to this
https://community.qlik.com/t5/New-to-QlikView/Need-percenatge/m-p/1764250#M394863
I want to show the percentage which is equal to 100% and its not null %.
for example: I have 12 users . in that 6 pass 4, fail , 2 NA. so now I want to show only (100%) for pass ,fail
it means 6 pass (60%) and 4 fail(40%) total 100% will not include other two Null values.
Hi @soniasweety
May be try like this
=Num(Count({<Status={'Pass'}>}Status)/count({<Status-={'Na'}>}Status), '0%')
=Num(Count({<Status={'Fail'}>}Status)/count({<Status-={'Na'}>}Status), '0%')
count({<Status-={'Na'}>}Status) <-- it doesn't include Na status
@soniasweety see the attached
Thanks for the update and quick reply. I'll be sure to keep an eye on this thread. Looking for the same issue. Bumped into your thread. Thanks for creating it. Looking forward for solution.