Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis for NA or blank value

Hi All,

I want to count Incident No. where RE_NAME is 'NA' or blank:

CODE:

 

Count

({(<RE_NAME={NA}>+<RE_NAME={' '}>)*(<INCIDENT_QUAL_STATUS={'Resolved'}>*<CLASS_DESC={'Incident'}>)}INCIDENT_NO

)

1 Solution

Accepted Solutions
Not applicable
Author

try this

Count({<RE_NAME={'NA', ''}>*<INCIDENT_QUAL_STATUS={'Resolved'}>*<CLASS_DESC={'Incident'}>}INCIDENT_NO)

or try this


Count({<RE_NAME={'NA', '-'}>*<INCIDENT_QUAL_STATUS={'Resolved'}>*<CLASS_DESC={'Incident'}>}INCIDENT_NO)

View solution in original post

7 Replies
Not applicable
Author

count(if(RE_NAME = 'NA' or RE_NAME = ' ' and INCIDENT_QUAL_STATUS= 'Resolved' and  CLASS_DESC= 'Incident',[Incident No]))

Not applicable
Author

updated code

Count({<RE_NAME={'NA', ' '}>*<INCIDENT_QUAL_STATUS={'Resolved'}>*<CLASS_DESC={'Incident'}>}INCIDENT_NO)

Not applicable
Author

This is not working out!

Not applicable
Author

Pls check..

Count({<RE_NAME={'NA',' '},INCIDENT_QUAL_STATUS={'Resolved'},CLASS_DESC={'Incident'}>}INCIDENT_NO)

regards-bika

Not applicable
Author

It's working but I want in terms of set expression.

Not applicable
Author

try this

Count({<RE_NAME={'NA', ''}>*<INCIDENT_QUAL_STATUS={'Resolved'}>*<CLASS_DESC={'Incident'}>}INCIDENT_NO)

or try this


Count({<RE_NAME={'NA', '-'}>*<INCIDENT_QUAL_STATUS={'Resolved'}>*<CLASS_DESC={'Incident'}>}INCIDENT_NO)

Sokkorn
Master
Master

Hi,

Not sure you have try this yet:

Count({$<[INCIDENT_QUAL_STATUS]={'Resolved'}, CLASS_DESC={'Incident'},[RE_NAME]={'NA'}>+<[RE_NAME]={' '}>} [INCIDENT_NO])

Regards,

Sokkorn