Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Morgoz
Contributor III
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:

TituloTipoContraBase
ÁcidoAtaqueAutotomía mitótica2
ÁcidoAtaqueCoraza2
ÁcidoAtaqueRegeneración2
Arco voltáicoAtaqueLicuable1
Aspirador compresorAtaqueSublimable3
Bloqueador mentalAtaqueEmpatía psiónica2
Cañón de hélio líquidoAtaqueAutotomía mitótica1
Cañón de hélio líquidoAtaqueLicuable2
Cañón de hélio líquidoAtaqueSublimable3
GranadasAtaqueCoraza1
GranadasAtaqueRegeneración1
Rayo láserAtaqueCoraza2

 

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
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Morgoz
Contributor III
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.