Dynamic chart based on rank based list box values

[vardhancse]

Hi,

Have one requirement is that,

Table:

LOAD * INLINE [

    Group, Target, Month, Year

    ABC, 10, Apr, 2017

    BCD, 20, May, 2017

    DEF, 30, Jun, 2017

    EFG, 5, Jul, 2017

];

Based on the value of Sum(Target), only top 2 groups should be displayed in table - Done using Aggr got the result

Now based on the first value from the top 2 , need to create one chart individually.

It should be dynamic, like any point of time to based on sum(target) t charts should be displayed.

[vardhancse]

gwassenaar‌

As suggested in some old posts used =if(aggr(rank(sum(Cost)),Zone)<=10,Zone)  and achievd the expected result.

But now issue is that if Sum(cost) = 100 for multiple rows, both the rows where getting displayed.

Created some text objects to displyaed the top 10 individually, but when Sum(cost) is same for multiple rows, both the values are getting displayed.

Could you please let me know any alternative my expected result.

[sunny_talwar · Accepted solution]

You can play around with two alternatives....

1) Continuous Ranking (no missing Rank)

2) or play around with some of the arguments within the rank function, specifically, mode and fmt

Rank ‒ QlikView

[vardhancse]

Thank you, will try now.

[vardhancse]

Thank you.

Used below condition and my issue for resolved.

=if(aggr(rank(sum(Cost),4),Zone)<=10,Zone)