topic Qualifier for Dimension in QlikView

Qualifier for Dimension

danielact — Fri, 01 Jul 2011 13:15:42 GMT

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?

Qualifier for Dimension

brenner_martina — Fri, 01 Jul 2011 13:18:32 GMT

Hi,

you can enter a dynamic dimension like this:

=If(filed>10,'true')

Greetings from Munich

Qualifier for Dimension

isaiah82 — Fri, 01 Jul 2011 13:19:32 GMT

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)

Qualifier for Dimension

isaiah82 — Fri, 01 Jul 2011 13:20:31 GMT

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

Qualifier for Dimension

richard_chilvers — Fri, 01 Jul 2011 15:01:28 GMT

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