Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I think with Dimension of Contra, use Measure:
-Sum( Base = Aggr(NoDistinct Max(Base), Contra))
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
I think with Dimension of Contra, use Measure:
-Sum( Base = Aggr(NoDistinct Max(Base), Contra))
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
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.