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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

count of distinct costumer in units greater than 3

I need to display in a chart dimension that repeat values over 3 times.


I try to solve my problem using "if" but and sum result but there is an error in expression.

Dimension of chart: [BUSINESS UNIT]


Expression

sum(AGGR(IF(Count ({(<[RAPP NDG] ={'*'}>) + ( <[RAPP COI] ={'*'}>) } DISTINCT [COSTUMER])>3, 1,0),[COSTUMER]))

I think that I need to solve problem with set analysis.

Labels (1)
2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Perhaps like this:

count({< [BUSINESS UNIT] ={"=count({<[RAPP NDG] ={'*'}>+<[RAPP COI] ={'*'}>} DISTINCT [CUSTOMER])>3"} >} [BUSINESS UNIT])


talk is cheap, supply exceeds demand
Not applicable
Author

I try it. It's ok! Thanks a lot!