Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

Not null

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.

3 Replies
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

Thanks & Regards,
Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Kushal_Chawda

@soniasweety  see the attached

 

Sawaynnn
Contributor
Contributor

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.