topic Aggregation of Sum w.r.t. Calculated Dimension in QlikView

Aggregation of Sum w.r.t. Calculated Dimension

Fri, 18 Jul 2014 09:03:27 GMT

In a pivot table, I have one calculated dimension with complex expression:

pick(1+match(IF([Corporate Account]='OTHER','[Sales Account]', '[Corporate Account]'),...,...,...),...,...,...,...)

In another dimension, I want to sum revenu with respect to this first dimension. More precisely, I want to have value for this new calculated dimension be 'A' or 'B' depending on the total revenue with respect to the first field.

So far, I came up with

=AGGR( IF(Sum(Revenue)>10,'A','B'),

$(=pick(1+match(IF([Corporate Account]='OTHER','[Sales Account]', '[Corporate Account]'),...,...,...),...,...,...,...)))

and this is not correct (for all rows, output is Null()).

Would you have an idea of what is the right syntax ?

Many thanks in advance

Re: Aggregation of Sum w.r.t. Calculated Dimension

MK_QSL — Fri, 18 Jul 2014 09:08:53 GMT

Provide sample date please

Re: Aggregation of Sum w.r.t. Calculated Dimension

Fri, 18 Jul 2014 09:09:39 GMT

i cannot share the data

Re: Aggregation of Sum w.r.t. Calculated Dimension

MK_QSL — Fri, 18 Jul 2014 09:41:11 GMT

You can obviously create dummy data.

Re: Aggregation of Sum w.r.t. Calculated Dimension

Fri, 18 Jul 2014 15:37:43 GMT

I am afraid I cannot share a document from the Personal Edition. If you have any idea on a possible source of error in the syntax, please let me know.