topic Re: Remove highest value from chart in QlikView

Remove highest value from chart

Anonymous — Tue, 30 Jun 2015 10:51:39 GMT

Hi,

How can i remove the highest value in the chart?

rubenmarin — Tue, 30 Jun 2015 11:13:00 GMT

Hi Marius, for just that bar you can try with:

If(Rank(YourActualExpression)>1, YourActualExpression)

If you want remove the dimension maybe using a calculated dimension:

Aggr(If(Rank(YourActualExpression)>1, DimensionField), DimensionField)

Tue, 30 Jun 2015 11:22:51 GMT

hi,

top(sales)-sum(sales)

will give u o/p hopw it will help to complete the task.

Thank you,

Balaji.k

Tue, 30 Jun 2015 11:23:27 GMT

Hi Marius,

One more option you have in Dimension limit, where you can limit the amount as shown below;

I hope it will help you

Regards

Tue, 30 Jun 2015 11:36:52 GMT

Its quite simple just use the below syntax removing any value greater than the specific number as shown below based on your requirement

SatyaPaleti — Tue, 30 Jun 2015 11:38:53 GMT

Hi Marius,

Here you can option to maintain certain limit

Path --> Chart Properties--> Dimension Limits

Thank you,

SatyaPaleti

Tue, 30 Jun 2015 11:48:33 GMT

Hi Marius,

Simple way, U can work on Properties of Object u can choose Dimension Limits tab then u will have option to restrict the highest value.

Ramya.