topic Re: Setting Dimension Limits in QlikView

Setting Dimension Limits

ogster1974 — Mon, 14 Sep 2015 09:57:27 GMT

HI Guys

I have a challenge I hope will be an easy one to resolve.

I have a stacked bar chart with 4 values in it which breaks down how a fund that's been earned is being used.

I need to show the top 10 Earners split by how its been used which can be derived 2 ways

1. Available + Expired + Transferred Out + Spent

2. Earned + Transferred In

I have tried including Earned + Transferred In as the first expression and setting it to invisible but it still takes up space on the chart.

How can I get around this?

Regards

Andy

Re: Setting Dimension Limits

avinashelite — Mon, 14 Sep 2015 10:10:11 GMT

You can try with Dimension Limit option in the chart rite?

or you can try with the Rank function

...please share your file will , which will give idea what your data and what your trying

Re: Setting Dimension Limits

ogster1974 — Mon, 14 Sep 2015 10:14:53 GMT

I cannot share the chart as client sensitive data. Hence the screen shot and description of the data involved.

I have tried the dimension limit. The issue is it using the first expression in this case that would be spent but I need to using a different expression which is Earned to derive the limit but cannot be displayed in the chart.

Re: Setting Dimension Limits

Anonymous — Mon, 14 Sep 2015 10:14:59 GMT

hi,

use calculated dimension:

=If(Aggr(Rank(Sum(Dim)), Dim) <= 10, Dim)

Re: Setting Dimension Limits

ogster1974 — Mon, 14 Sep 2015 15:04:18 GMT

Thanks guys using the calculated dimension helped get to the bottom of my issue.

Regards

Andy