Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

alemberg
New Contributor II

DISTINCT

Folks the following expression is working for me within a KPI extension. I am however looking for the result to come back DISTINCT with the count. What do i need to add to this expression to make that happen.

Count({$<[Bank KPI - # of Clients pending On-Boarding]={Y}>}Client)

1 Solution

Accepted Solutions
MVP
MVP

Re: DISTINCT

May be this:

Count(DISTINCT {$<[Bank KPI - # of Clients pending On-Boarding]={Y}>}Client)

2 Replies
srchagas
Contributor III

Re: DISTINCT

did you try use?

Count(  DISTINCT {$<[Bank KPI - # of Clients pending On-Boarding]={Y}>}Client)

MVP
MVP

Re: DISTINCT

May be this:

Count(DISTINCT {$<[Bank KPI - # of Clients pending On-Boarding]={Y}>}Client)