Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

Exclude Nulls

Hi all,

I have a column  Status

in that values are like below

Status

success

"success with no issue "

Failed

Unsuccessfull

-

so here  my requirement is  :    Caluclate the  Failed %

logic :  if(Status='successful' or Status='success With No Issues' or close_code='successful_issues', 'Yes','No') as StatusFlag,

Front end :

count({<StatusFlag={'No'}>}Number)

/count(Number)  

its working but  in data I have null values  if I take  flag value "No"   except success null also taking into consideration so  I want to exclude that  how to do?

12 Replies
sudhirpkuwar
Partner
Partner

You just need the Failed % right....?

singbittoo
Creator
Creator

tamil's expression will work in front end, for script level

you can write

** the below one is also tamil's code only just the '' i replaced with 'null'

If(Isnull(Status),'null', If(Match(Status,'successful','success With No Issues','successful_issues') , 'Yes','No')) as StatusFlag

and in your older expression will work fine

soniasweety
Master
Master
Author

yes sudhir