topic Not null in QlikView

Not null

soniasweety — Thu, 26 Nov 2020 08:15:31 GMT

Hi @MayilVahanan @Vegar

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.

Re: Not null

MayilVahanan — Thu, 26 Nov 2020 10:24:43 GMT

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

Re: Not null

Kushal_Chawda — Thu, 26 Nov 2020 10:25:57 GMT

@soniasweety see the attached

Re: Not null

Sawaynnn — Sat, 28 Nov 2020 06:01:35 GMT

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.