topic Re: Calculated Dimension using sum() function not working in QlikView

Calculated Dimension using sum() function not working

Anonymous — Tue, 20 Jan 2015 09:18:21 GMT

Hi all,

I have a problem regarding using a calculated dimension.

The expression looks as follows:

=if (sum () = sum () , Store)

This expression should only show me the Stores where A equals to B, but I'm getting

an error that states //Error in calculated dimension

Do you maybe have a solution to my problem?

Thanks!

Re: Calculated Dimension using sum() function not working

alexandros17 — Tue, 20 Jan 2015 09:22:19 GMT

You cannot use Sum in a dimension field until you use aggr.

So you should change the formula to something like

if (Aggr(sum (, mydimension)) = Aggr(sum (,mydimension)) , Store)

but this is not reccomanded because performance decrease

Re: Calculated Dimension using sum() function not working

Tue, 20 Jan 2015 09:26:20 GMT

try to create a new dimension at back end for the same condition then use this at front end,at front end creation of this kind of calculated dimension is not recommended...

Re: Calculated Dimension using sum() function not working

its_anandrjs — Tue, 20 Jan 2015 09:32:02 GMT

Hi,

Rather than use of SUM in expression use variables and store that value into the variable and use the variable for condition check but it is not correct way. But if it is need you can go for variables.

Regards,

Anand

Re: Calculated Dimension using sum() function not working

jagan — Tue, 20 Jan 2015 09:38:27 GMT

Hi,

Try like this

Dimension : Store

Expression: =if (sum () = sum () , Your expression goes here)

Hope this helps you.

Regards,

Jagan.

Re: Calculated Dimension using sum() function not working

Anonymous — Tue, 20 Jan 2015 09:39:51 GMT

Try like this

=Sum(If(FieldA=FieldB,Store))

Re: Calculated Dimension using sum() function not working

its_anandrjs — Tue, 20 Jan 2015 09:59:43 GMT

Hi Stefan,

1. First way is use calculated dimension for this table

LOAD * Inline
[
A,B,store,Value
10,10,A,2346
20,20,B,2435
30,30,C,5689
];

Dim:- =if (sum (TOTAL ) = sum (TOTAL ) , store)

Expre:- Sum(Value)

2. Second way is use this condition in the expression part

Dim:- store

Expre:- =if (sum (TOTAL ) = sum (TOTAL ) , Sum(Value),0)

Regards

Anand

Re: Calculated Dimension using sum() function not working

Anonymous — Tue, 20 Jan 2015 10:48:20 GMT

Hi everyone, so I found a solution.

Instead of using a calculated dimension, I just changed my expressions to the following:

=if(sum() = sum() , sum())

this expression says: if the sum of A equals to the sum of B, give the sum of A..

using this method, my straight table shows all Stores where A = B

Thanks for the feedback guys, you're all brilliant!