topic Re: countif in QlikView

countif

samuel_brierley — Wed, 04 Sep 2013 08:51:30 GMT

Hi First I want to say thank you for all the help people are on this site,

can somebody explain where im going wrong in this expression?

if( [Fault Status]={HARD} count( [Fault Detected]) - count ({$< [Fault Cleared] = {"<=$(=Max([Date Detected]))"}>} [Fault Cleared] )

the 2 count expressions work fine its the if statement that is an issue, or maybe how im combining the two,

its supposed to say if Fault status = HARD do the following expression

christophebrault — Wed, 04 Sep 2013 08:56:32 GMT

I supose you want to do this :

if( [Fault Status]='HARD', count( [Fault Detected]) - count ({$< [Date Detected] = {"<=$(=Max([Date Detected]))"}>} [Fault Cleared] ))

swuehl — Wed, 04 Sep 2013 08:56:46 GMT

Fault Status must have an unambiguous value in the scope of the expression to work (like Fault Status as dimension for the expression), then just try

if( [Fault Status]='HARD' ,

count( [Fault Detected] ) - count ({$< [Fault Cleared] = {"<=$(=Max([Date Detected]))"}>} [Fault Cleared] )

)