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: 
gauravgg
Partner - Creator
Partner - Creator

add condition in set analysis?

I have the following expression for top 10 Customers

count({<[Customer Name]={"=rank(count(total <[Customer Name]> [Ticket No]))<=10"}>}[Ticket No])

I want to add the following two condition in expression

1) Customer_type=Customer

2) WildMatch(GROUP,'*operations*')=1

Thanks in advance.

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Perhaps this does what you want:

count({<[Customer_type]={'Customer'},GROUP={'*operations*'} [Customer Name]={"=rank(count(total <[Customer Name]> [Ticket No]))<=10"}>}[Ticket No])


talk is cheap, supply exceeds demand
sunny_talwar

or this:

Count({<[Customer_type]={'Customer'},GROUP={'*operations*'}, [Customer Name]={"=Rank(Count(TOTAL <[Customer Name]> {<[Customer_type]={'Customer'},GROUP={'*operations*'}>} [Ticket No]))<=10"}>} [Ticket No])