Count And expression

[samuel_brierley]

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

[CELAMBARASAN]

Try with this

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

or

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

[MayilVahanan]

HI

Try like this

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

[#4]

try this this

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

[samuel_brierley]

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

[CELAMBARASAN]

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

[samuel_brierley]

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