topic use subtotal in an expression in QlikView

use subtotal in an expression

Thu, 16 Dec 2010 12:27:19 GMT

hi,

i have a pivot table with 2 dimensions and 3 expressions

example :

tt = subtotal of budget marketing for Code_RAy =10 *(CAHT) / subtotal of CAHT for Code_Ray=10

tt=( 54045,1315 * 1604318,866)/1675839,636

what function returns the subtotal field value ???

how to calculate this expression???

thanks,

use subtotal in an expression

Thu, 16 Dec 2010 14:46:18 GMT

hi,

i found the answer to my question: the use of the function dimensionality

(if(Dimensionality()=2,sum(total <Code_Ray,Code_Etab> Budget marketing),if(Dimensionality()=1,sum(Total <Code_Ray> Budget marketing),sum(Total Budget marketing)))*sum(CAHT)))

/if(Dimensionality()=2,sum(total <Code_Ray,Code_Etab> CAHT),if(Dimensionality()=1,sum(Total <Code_Ray> CAHT)),sum(Total CAHT)))