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: 
Not applicable

Displaying second largest value

hi

i have a chart which contains incident categories . i need to create norther 5 charts which shows d top 5 categories one by one. d largest i can get it done. but how can i display ONLY the second largest value ???

my equation to calculate the count of categories as follows :

count(if(year(today())=fp_year) and cat_tier='Fail',IncID))

if some one could help me in this issue i would really appreciate it

thank you in advance

4 Replies
Gysbert_Wassenaar

Perhaps this:

count({<MyCategoryDimensionHere={"=rank(count({<fp_year={'$(=year(today))'},cat_tier={'Fail'}>} IncID))=2"}, fp_year={'$(=year(today))'},cat_tier={'Fail'}>} IncID)

or maybe

max(aggr(count({<fp_year={'$(=year(today))'},cat_tier={'Fail'}>} IncID),MyCategoryDimensionHere),2)


talk is cheap, supply exceeds demand
Not applicable
Author

hi

i tried this

max(aggr(count({<fp_year={'$(=year(today))'},cat_tier={'Fail'}>} IncID),MyCategoryDimensionHere),2)

but it show falls values but if i remove the dimension in the dimension tab it shows the correct value but it dosent show the category name . what can i do for that??

Anonymous
Not applicable
Author

How about the attached solution?

One expression (for the Bar) similar to MAX(AGGR(SUM(Sales),Market),2)

One expression (to be shown on the axis) similar to ONLY(IF(AGGR(RANK(SUM(Sales),4),Market)=2,Market))

Kind regards

Niklas

Anonymous
Not applicable
Author

Or a bit less complicated...  😉

Use a calculated dimension with IF(AGGR(RANK(SUM(Sales),4),Market)=2,Market)

Suppress Null values

And then just add SUM(Sales) as your expression.

Niklas