Qlik Community

Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
gadwinjer
Not applicable

Group by in measure expression (#1 KPI)

Hello,


I would like to group by a count expression and get the max of the values but I don't know how :

In #1 KPI there is no dimension (that makes sense for only 1 value ) Could someone tell me how can I do something like this:

     MAX(COUNT(DINSTINCT [colonneA]) GROUPBY [colonneB])



Thanks

1 Solution

Accepted Solutions
sunny_talwar
Not applicable

Re: Group by in measure expression (#1 KPI)

May be this:

Max(Aggr(Count(DISTINCT colonneA), colonneB))

2 Replies
sunny_talwar
Not applicable

Re: Group by in measure expression (#1 KPI)

May be this:

Max(Aggr(Count(DISTINCT colonneA), colonneB))

gadwinjer
Not applicable

Re: Group by in measure expression (#1 KPI)

Why did I suppose that would be harder ? Thank you !