This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have a column Status
in that values are like below
"success with no issue "
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 :
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?
You just need the Failed % right....?
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