topic Set analysis for NA or blank value in QlikView

Set analysis for NA or blank value

Fri, 12 Jul 2013 05:06:45 GMT

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

)

Fri, 12 Jul 2013 05:09:18 GMT

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

Fri, 12 Jul 2013 05:11:21 GMT

updated code

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

Fri, 12 Jul 2013 05:29:58 GMT

This is not working out!

Fri, 12 Jul 2013 05:32:12 GMT

Pls check..

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

regards-bika

Fri, 12 Jul 2013 05:33:07 GMT

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

Fri, 12 Jul 2013 05:44:26 GMT

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 — Fri, 12 Jul 2013 06:21:42 GMT

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