Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggregation of Sum w.r.t. Calculated Dimension

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

4 Replies
MK_QSL
MVP
MVP

Provide sample date please

Not applicable
Author

i cannot share the data

MK_QSL
MVP
MVP

You can obviously create dummy data.

Not applicable
Author

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.