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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Alyona
Contributor III
Contributor III

How to implement the set analysis in set analysis

Hi Qlik experts!

 

I need your help! 

I have the calculation of [Volume] based on selection in [Date] field as this one: 

sum({<[Date]={">=$(=yearstart(max([Date]))) <=$(=max([Date]))"} > } [Volume])

 

But now I need to calculate the count of distinct customers which have the volume above. 

I tried something like this: 

count({<[Customer ID] = {"= sum({<[Date]={">=$(=yearstart(max([Date]))) <=$(=max([Date]))"} > } [Volume]) > 0"}>} distinct [Customer ID])

 

But it doesn't work.  Also I tried to use variable for calculation the sum of volume and to use it the count calculation, but it was also without success. 

 

Could anybody help me, how to implement this calculation? 

Labels (1)
10 Replies
Lakshmi22it
Contributor
Contributor

Can you please explain me this code i wanna learn 🙂