topic Dimension limits on charts in QlikView

Dimension limits on charts

suryaa30 — Wed, 25 Nov 2020 16:16:04 GMT

Hi In below case I have two dimensions and 3 expressions

When I select Dimension 1 there is multiple values for Dimension 2

I have to limit values of the Dimension 2 to only those having 80% contribution based on one of the expression.

The dimension limit works for straight table but not the chart shown. what is the possible reason?

ramasaisaksoft — Fri, 06 Oct 2017 11:39:46 GMT

Hi Surya,

What is your expected output in that Straight table

K7 is having 7 values ,so what is your expected output?

if possible attache the sample .qvw file with sample data.So that our folks will help to you ASAP.

suryaa30 — Fri, 06 Oct 2017 11:44:01 GMT

The values in the straight table are correct.When K7 has been selected it should show only Retainers contributing to 80%.

But in the bubble chart I see additional retainers apart from the ones needed

avinashelite — Fri, 06 Oct 2017 12:02:23 GMT

Try like this , calculate the 80% in your expression andd then

if(Expression >80 , Expression )