Discussion Board for collaboration related to Creating Analytics for QlikView.
I have two fields Attendance and Defects. I am trying to count each 'Y' in both fields. The expression I wrote:
Count(IF(Attendance='Y', 1 AND Defects='Y',1))
It is not counting each 'Y' it seems to be ignoring the second 'Y' if it appears in the same row. I have included attachments below of my chart and my data model. In the attachment below I am supposed to have 6 Y not 5 Y. Any help is appreciated.
Solved! Go to Solution.
Massimo Grossi: That expression only counts the Y when both Attendance AND Defects =Y so in the Attachment above I only have 1 time where I have Y in both Attendance AND Defects so that's why I got '1' as a result from that expression. I want to count each 'Y' separate. Thanks for the reply though!
The expression you have written counts each individual 'Y', which is what I needed!! Thank you so much!!! This worked! I feel very silly though. I have been working on this for a while and it was right in front of me!