Not null

[soniasweety]

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.

[MayilVahanan]

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

[Kushal_Chawda]

@soniasweety  see the attached

[Sawaynnn]

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.