topic Re: Dynamic chart based on rank based list box values in QlikView

Dynamic chart based on rank based list box values

vardhancse — Wed, 20 Sep 2017 06:33:31 GMT

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 — Mon, 25 Sep 2017 06:43:43 GMT

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 — Mon, 25 Sep 2017 11:25:14 GMT

You can play around with two alternatives....

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

vardhancse — Tue, 26 Sep 2017 04:07:13 GMT

Thank you, will try now.

vardhancse — Tue, 26 Sep 2017 06:55:43 GMT

Thank you.

Used below condition and my issue for resolved.

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