Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

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.

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

Highlighted
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