Count And

[samuel_brierley]

Dropbox - qlikview.xlsmhttps://www.dropbox.com/s/h9mqhmc58yc0l2m/qlikview.xlsm

Hi first of all thanks for any help, Ive asked this question before wiht no luck so Im going to try and explain it abit better.

I would like 2 expressions,

the first will simply count the amount of Fault cleared that is greater than the max fault detected, the answer will be 99.

the second will state the above AND Fault staus equals "INTER" this should be 1.

thanks for your help

[pgrenier]

Good day Samuel,

Please see attached QVW file, I feel you might find your answers.

Cheers,

Philippe