Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

CountIfs equivalent in Qlikview


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.

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

Appreciate any help in this matter as I have been searching for it for almost two days now. Eagerly waiting for a response

0 Replies