topic CountIfs equivalent in Qlikview in QlikView https://community.qlik.com/t5/QlikView/CountIfs-equivalent-in-Qlikview/m-p/1177249#M914370 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have been trying to do something similar to Excel count ifs in Qlikview Straight Table but without any success. I have searched the forums and took few tips but I am still not getting the count that I am expecting.</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Please find attached the sample excel file with the count ifs formula. I am able to successfully filter on Month and KPI in the set analysis however, I am unable to count where value in Source Location=Location </SPAN></P><P></P><P>Appreciate any help in this matter as I have been searching for it for almost two days now. Eagerly waiting for a response <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z CountIfs equivalent in Qlikview https://community.qlik.com/t5/QlikView/CountIfs-equivalent-in-Qlikview/m-p/1177249#M914370 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have been trying to do something similar to Excel count ifs in Qlikview Straight Table but without any success. I have searched the forums and took few tips but I am still not getting the count that I am expecting.</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Please find attached the sample excel file with the count ifs formula. I am able to successfully filter on Month and KPI in the set analysis however, I am unable to count where value in Source Location=Location </SPAN></P><P></P><P>Appreciate any help in this matter as I have been searching for it for almost two days now. Eagerly waiting for a response <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/CountIfs-equivalent-in-Qlikview/m-p/1177249#M914370 2020-11-25T16:16:04Z