Dimension Limits on Second Expression?

Fri, 29 Sep 2017 18:47:21 GMT

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.

Re: Dimension Limits on Second Expression?

Clever_Anjos — Fri, 29 Sep 2017 19:42:10 GMT

supposing your column with transaction is the 3rd

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

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

topic Re: Dimension Limits on Second Expression? in QlikView

Dimension Limits on Second Expression?

Re: Dimension Limits on Second Expression?