Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
danielact
Partner
Partner

Qualifier for Dimension

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?

1 Solution

Accepted Solutions
isaiah82
Creator III
Creator III

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)

View solution in original post

4 Replies
brenner_martina
Partner
Partner

Hi,

you can enter a dynamic dimension like this:

=If(filed>10,'true')

Greetings from Munich

isaiah82
Creator III
Creator III

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)

View solution in original post

isaiah82
Creator III
Creator III

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
Specialist
Specialist

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