Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sambrown
New Contributor

Can I limit a dimension along on Y axis?

Hi,

I'm creating a scatter plot where on the Y axis I have 'transfer value (£)' and on X I have the 'start date'. I want to limit the dimension where the transfer value '>0' (nice and easy). However, when I go to limit the dimension it says 'Calculated on Dimension: Start Date' and I have no option to change it to use the other measure.

If I swap the measures around, I can limit it by the transfer value but it makes the graph confusing to read.

My question is, can I put a limit on the transfer value while keeping it on the Y axis?

1 Solution

Accepted Solutions
OmarBenSalem
Esteemed Contributor

Re: Can I limit a dimension along on Y axis?

Change YourSecondMeasure:

from:

sum(YourSecondMeasure)

to:

if(sum(YourSecondMeasure)>0,sum(YourSecondMeasure))

2 Replies
OmarBenSalem
Esteemed Contributor

Re: Can I limit a dimension along on Y axis?

Change YourSecondMeasure:

from:

sum(YourSecondMeasure)

to:

if(sum(YourSecondMeasure)>0,sum(YourSecondMeasure))

sambrown
New Contributor

Re: Can I limit a dimension along on Y axis?

Always helps to have a fresh pair of eyes look at something! Thank you so much!

Community Browser