topic Re: Conditional Dimensions/Expressions in QlikView

Conditional Dimensions/Expressions

Wed, 19 Sep 2012 13:22:58 GMT

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

Wed, 19 Sep 2012 14:44:16 GMT

Here is an example.

Re: Conditional Dimensions/Expressions

Thu, 20 Sep 2012 14:11:39 GMT

Hi rebeccad

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

Thu, 20 Sep 2012 14:34:43 GMT

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

Thu, 20 Sep 2012 15:23:20 GMT

Thanks for ur help the last option work fine !!

Re: Conditional Dimensions/Expressions

Fri, 15 Mar 2013 11:09:28 GMT

Hello Rebecca,

could you please give me any advice about my problem? Maybe you already met this.

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

Fri, 15 Mar 2013 13:05:43 GMT

Hi mirek.zebrak,

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

Re: Conditional Dimensions/Expressions

Fri, 15 Mar 2013 13:23:31 GMT

Hi Rebecca,

thank you for your reply. Your solution is one of possible solutions. I figured this solution:

Instead this:

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

This:

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

Have a nice day!