topic Re: Show only the 10 largest ABSOLUET values in QlikView

Show only the 10 largest ABSOLUET values

Tue, 26 Aug 2014 03:42:44 GMT

Hi,

Is there a way to show in a graph the 10 largest absolute values? (indeed I have positive and negative value in my bar chart).

Thanks.

Re: Show only the 10 largest ABSOLUET values

jagan — Tue, 26 Aug 2014 04:11:04 GMT

Hi,

In expression use Fabs(Expression), and restrict the records, sort the chart by Expression Descending in Sort tab and by using Dimension Limits - > Show only -> Largest 10 values .

Regards,

Jagan.

Re: Show only the 10 largest ABSOLUET values

Tue, 26 Aug 2014 05:07:24 GMT

Thanks for the quick answer but I was not precise enough.

Is it possible to keep showing positive/negative values on the graph but only show the 10 largest absolute values?

Re: Show only the 10 largest ABSOLUET values

Tue, 26 Aug 2014 05:11:19 GMT

Hi Jerome,

Please check the attached app.

Try to use calculated dimension as below

=aggr(if(rank(fabs(Sum(Value)))<=10,Dimension),Dimension)

Keep the Label as "Dimension", also check the "Suppress When Value is Null" in the same properties pane for Dimension

In the "Expressions" use "Sum(Value)" with respective Label "Value"

Finally in the "Sort" properties pane, use Expression as sort order for Dimension, with the below expression

rank(fabs(Sum(Value)))

Order as Ascending

Kindly replace the Dimension and Value with your required dimension and fact values

Thanks,

Sri

Re: Show only the 10 largest ABSOLUET values

tresB — Tue, 26 Aug 2014 05:16:29 GMT

Use Fabs(), may be something like:

Calculated dimension: =Aggr(If(Rank(Fabs(Sum(Expression))) <= 10,Customer),Customer)

Re: Show only the 10 largest ABSOLUET values

jagan — Tue, 26 Aug 2014 05:29:07 GMT

Hi,

It is not possible to show positive and negative values in graph, use Fabs() to convert and use another expression without fabs() and display it as a Label by using

Chart Properties -> Expression -> Show as Popup

Regards,

Jagan.

Re: Show only the 10 largest ABSOLUET values

Tue, 26 Aug 2014 05:38:43 GMT

Thanks!

Re: Show only the 10 largest ABSOLUET values

Tue, 26 Aug 2014 05:56:05 GMT

Hi Jerome,

If this query is answered, kindly mark the same as answered.

Thanks,

Sri