topic Count And expression in QlikView

Count And expression

samuel_brierley — Fri, 30 Aug 2013 10:28:26 GMT

currently I have 2 expressions and 2 questions regarding them

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

=COUNT( {$<[Fault Status]={HARD}>} [Fault Status] )

the first one counts all the times the date Cleared is NOT the same as the date detected, how can i modify that expression so that it counts all that when Date Cleared is greater than the max date detected.

the second expression reads to count all the Fault Status when the cell reads HARD, is there a way to combine this with the equation that you have suggested to read

count everything where date Cleared is greater than MAX date detetced AND fault status is HARD.

thanks for the help

Re: Count And expression

CELAMBARASAN — Fri, 30 Aug 2013 10:33:24 GMT

Try with this

COUNT( {$<[[Date Cleared]={">=$(Max([Date Detected]))"},[Fault Status]={HARD}>} [Fault Id] )

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

Re: Count And expression

MayilVahanan — Fri, 30 Aug 2013 10:35:37 GMT

Try like this

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

Re: Count And expression

Fri, 30 Aug 2013 10:39:00 GMT

try this this

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

Re: Count And expression

samuel_brierley — Fri, 30 Aug 2013 11:06:30 GMT

Ive tried all the variations of the above expressions and htey dont give the correct answer, not sure where they even get theyre answer from, manybe if you can help create an expressions that simply states count when Date cleared is greater than max Date detetected. thanks

Re: Count And expression

CELAMBARASAN — Fri, 30 Aug 2013 11:10:34 GMT

Its better if you provide the sample application which shows your problem.

Re: Count And expression

samuel_brierley — Fri, 30 Aug 2013 11:50:02 GMT

ye no problem, the attached is just the two collumns I want to count,

i.e count all those in date cleared that are greater than the max of Date Detected,

and count all those in date cleared that are greater than the max of Date Detected and that are Hard Faults

http://https://www.dropbox.com/s/h9mqhmc58yc0l2m/qlikview.xlsm

Tanks for the Help