Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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
Highlighted
Not applicable

Re: Set analysis for NA or blank value

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

Re: Set analysis for NA or blank value

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

Not applicable

Re: Set analysis for NA or blank value

updated code

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

Not applicable

Re: Set analysis for NA or blank value

This is not working out!

Not applicable

Re: Set analysis for NA or blank value

Pls check..

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

regards-bika

Not applicable

Re: Set analysis for NA or blank value

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

Highlighted
Not applicable

Re: Set analysis for NA or blank value

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

Sokkorn
Honored Contributor

Re: Set analysis for NA or blank value

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