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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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