7 Replies Latest reply: Mar 15, 2013 9:23 AM by Miroslav Žebrák

# Conditional Dimensions/Expressions

Hi Dear QV Community

Based on this article http://community.qlik.com/message/172659#172659 , has found that in a graph where you have a number and expression and X number of dimensions with conditionals for display according to a selection, and expressions are always calculated.

Let me know any method or technique to make only selected expressions are calculated. Can anyone suggest something?

• ###### Re: Conditional Dimensions/Expressions

Here is an example.

• ###### Re: Conditional Dimensions/Expressions

Thanks for ur help, I have a table with this solution(Expressions and dimentions with conditional) about twelve expresssions and twenty dimentions, the model size is 800MB (60 Milliion rows).

My problem is performance with this table becose always calculate all expressions. The asociative model is formed for one big fact table and four dimention table, the keys are numeric and has 100% relation.

• ###### Re: Conditional Dimensions/Expressions

Oh I think I see what you mean. You can set it up so that the report does not calculate unless certain selections are made to narrow the data. Take a look at the attached example.

• ###### Re: Conditional Dimensions/Expressions

Thanks for ur help the last option work fine !!

• ###### Re: Conditional Dimensions/Expressions

Hello Rebecca,

I have dimensions in listbox which are similar. That mean that some of them contains same words.

Customer

Customer Phone

Customer Country

When "Customer phone" is selected, in table "Customer" will appear as well. Is there any chance to use theese similar names in list box with dimensions? Now is this conditional expression in use:

=SubStringCount(Concat(Fields, '|'), 'Customer')

Thank you!

• ###### Re: Conditional Dimensions/Expressions

Hi mirek.zebrak,

You can add an additional field to use as the Lookup.  See attached.

• ###### Re: Conditional Dimensions/Expressions

Hi Rebecca,

=SubStringCount(Concat(Fields, '|'), 'Customer')

This:

=SubStringCount(Concat(Fields, '|')&'|', 'Customer|')

Have a nice day!