Qualifier for Dimension

[danielact]

This may be really simple, and I'm just missing the answer.

I have a table that is using only one dimension (with a few expressions). I want to only show the ones that meet a certain criteria for the dimension - let's say where the value is greater than 10. Is there a way to do this?

[brenner_martina]

Hi,

you can enter a dynamic dimension like this:

=If(filed>10,'true')

Greetings from Munich

[isaiah82 · Accepted solution]

Hi - when you say "value is greater than 10" I presume this is based on an expression column and not some attribute right?  If the latter, I would build out a separate dimension field in your script.

If based on an expression, you can use the Aggr function along with an IF in your dimension to accomplish this; here's an example

If(Aggr(Sum(Sales),DimensionField)>10, DimensionField)

[isaiah82]

One additional note > with the above you would want to check the "Supress When Value is Null" box on the calculated dimension.  -Isaiah

[richard_chilvers]

Hi

I believe I read somewhere that it is best to avoid calculated dimensions (ie. expressions as dimensions). As Isaiah has said, the calculation can be made in the script. But this may become inconvenient if it occurs alot.

I'm surprised QlikView does not have a filter facility in charts to deal with this.

Richard