Dimension Limits on Second Expression?

[#1]

Hi,

I've created a scatter chart that plots customers by transaction date and sum of sales.  I'd like to limit this chart to large transactions (over $250k).  I thought that I would be able to simply use the Dimension Limits tab to accomplish this.  Unfortunately, I realized that the Dimension Limits tab in the chart properties only applies to the FIRST expression.  This means I had to promote my sum of sales expression to the top to allow the dimension limitation to work which caused my axes to flip.

Is there a work-around to this functionality? Can I force my scatter to flip axes assignment? Should I be using Dimension Limits at all in place of set analysis?

Thank you in advance for any consideration.

[Clever_Anjos]

supposing your column with transaction is the 3rd

1. Remove Dimension Limits
2. Change all expressions to If(Column(3)>250000, <original expression>)
3. Change 3rd expression to If( <original expression> > 250000, <original expression>)

this will make all rows to have empty values and qlik will supress them