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

How to use set analysis

Hello

I use the following set analysis in an expression, but it doesn't work.

=Count(DISTINCT{$<[Type dossier (code)]={4},[Geraamde bedrag]={">=75000"},[Type dossier (code)]={3},[Geraamde bedrag] = {">=22000"}>}RFQ)

It only gives as result the records :
Type dossier (code)]={3},[Geraamde bedrag] = {">=22000"}

Can somebody help me ?

Thanks in advance

Marc

20 Replies
Not applicable
Author

according to me your requirement is to get count of values has (code 4,and >75000)

+(code 3,and >22000)

so its best to go with



=Count(DISTINCT{$<[Type dossier (code)]={4},[Geraamde bedrag]={">=75000"}>}RFQ)

+


Count(DISTINCT{$<[Type dossier (code)]={3},[Geraamde bedrag] = {">=22000"}>}RFQ)