Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how to calculate other values in text box

Hi,

  I write the formula for finding top 2 value by using of first sorted value function.

num(firstsortedvalue(aggr(count(SESSIONID),HUB),-aggr(count(SESSIONID),HUB),2) ,'#,##0')

but i have to write formula for other values.please help me,

Thanks,

1 Solution

Accepted Solutions
anbu1984
Master III
Master III

Try this

=Concat(If(aggr(Rank(count(SESSIONID)),HUB) > 3,aggr(count(SESSIONID),HUB)),',')

View solution in original post

5 Replies
anbu1984
Master III
Master III

Do you mean you need all the counts?

Anonymous
Not applicable
Author

Hi anbu,

  thanks for your reply.

Actually i have formulas for top1,top2,top3 values i want to formula for remaining counts(like others option of dimention limit tab of chart property).

Thanks,

anbu1984
Master III
Master III

Replace 3 by number of values you want to display

=Concat(If(Rank(aggr(count(SESSIONID),HUB)) <= 3,aggr(count(SESSIONID),HUB)),',')

Anonymous
Not applicable
Author

Hi Anbu,

When i am trying to use your formula it shows some error

My exact need is i  want other than top3 values.

please help me,

Thanks,

anbu1984
Master III
Master III

Try this

=Concat(If(aggr(Rank(count(SESSIONID)),HUB) > 3,aggr(count(SESSIONID),HUB)),',')