Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
george456
Creator
Creator

Count if based on set analysis

Dear Community

I have a question with regards to a count if:

I need to count unique customer ID based on a set analysis: 

Rangesum(Above(sum({<Time_Groups_Total={'Month Folder'},Sub_Category={'Drinks'}>}if(Year2Date(Trans_Month,0,if(MONTH(vMaxMonth)>11,1,MONTH(vMaxMonth)+1),vMaxMonth),$(vMeasure))/
sum(total{<Time_Groups_Total={'Month Folder'},Sub_Category={'Drinks'}>}if(Year2Date(Trans_Month,0,if(MONTH(vMaxMonth)>11,1,MONTH(vMaxMonth)+1),vMaxMonth),$(vMeasure)))), 0, rowno()))

The above should be counting customers ID where the set analysis is smaller than 80%

I have placed this set analysis in a Variable .

Please advise

0 Replies