App Development

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
cancel
Showing results for
Did you mean:
Contributor III

Get number of times a maximum value occurs on a dimension

Hello,

I need to show in a graph the numbre of times (count) the maximum value of "Base" occurs on the dimension "Contra".

Here is the table:

 Titulo Tipo Contra Base Ácido Ataque Autotomía mitótica 2 Ácido Ataque Coraza 2 Ácido Ataque Regeneración 2 Arco voltáico Ataque Licuable 1 Aspirador compresor Ataque Sublimable 3 Bloqueador mental Ataque Empatía psiónica 2 Cañón de hélio líquido Ataque Autotomía mitótica 1 Cañón de hélio líquido Ataque Licuable 2 Cañón de hélio líquido Ataque Sublimable 3 Granadas Ataque Coraza 1 Granadas Ataque Regeneración 1 Rayo láser Ataque Coraza 2

So, for example for "Licuable" the maximum "base" is 2 and it occurs 1 time. And for "Sublimable" the maximum is 3 and it occurs 2 times.

I had tried a bar char with dimension "Contra" and metric:

Count(Aggr(Max(Base),Contra)) but it is not working.

Thank you.

1 Solution

Accepted Solutions
MVP

I think with Dimension of Contra, use Measure:

-Sum( Base = Aggr(NoDistinct Max(Base), Contra))

2 Replies
MVP

I think with Dimension of Contra, use Measure:

-Sum( Base = Aggr(NoDistinct Max(Base), Contra))

Contributor III
Author

Thank you so much Rwunderlich, it worked perfect.

Could you please share a link or some knowledge about how does that measure works? I'm quite new in Qlik Sense and I hadn't seen a formula like that before.

Thanks again.