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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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])