Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

gauravgg
New Contributor III

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.

Tags (1)
2 Replies

Re: add condition in set analysis?

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

Re: add condition in set analysis?

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])

Community Browser