topic not getting the expected count... in QlikView

not getting the expected count...

Fri, 27 Sep 2013 12:32:31 GMT

(CaseAge='>30',
Count(if(Interval(DATE((date(Today(),'DD/MM/YYYY')-date(INCIDENT_DATE,'DD/MM/YYYY')),'DD/MM/YYYY'),'DD')>30
AND NOT STATUS_DESC='Resolved'AND NOT STATUS_DESC='Cancelled' AND
NOT WildMatch(UPPER(CUSTOMER_NAME),'*EAST*','*WEST*','*SOUTH*','NORTH*','KSA*','DUBAI')
AND CLASS_DESC='Incident'and WildMatch(UPPER(CUSTOMER_NAME),'*ERICSSON*','*NOKIA*','*NSN*'),IN_INCIDENT_NO))

Please correct the above if have something wrong in the expression...

Re: not getting the expected count...

srchilukoori — Fri, 27 Sep 2013 12:38:34 GMT

Use the wildmatch as shown below, which ever matches your requirement. Wildmatch returns the position of the <Data1> in the <Fieldname>. If this equals to 0, it means <Data1> is not part of the string in <Fieldname>.

Wildmatch(<fieldname>, <Data1>, <Data2>,...) <> 0 or

Wildmatch(<fieldname>, <Data1>, <Data2>,...) =0

Re: not getting the expected count...

er_mohit — Fri, 27 Sep 2013 12:39:18 GMT

try this

if(CaseAge='>30',
Count(if(Interval(date(Today(),'DD/MM/YYYY')-date(INCIDENT_DATE,'DD/MM/YYYY'),'DD')>30
AND STATUS_DESC<>'Resolved' AND STATUS_DESC<>'Cancelled' AND
CUSTOMER_NAME<> WildMatch(UPPER(CUSTOMER_NAME),'*EAST*','*WEST*','*SOUTH*','NORTH*','KSA*','DUBAI')
AND CLASS_DESC='Incident' and WildMatch(UPPER(CUSTOMER_NAME),'*ERICSSON*','*NOKIA*','*NSN*'),IN_INCIDENT_NO))