store expression of a chart in variable

[Anonymous]

hello,

i have a straight table chart with:

-one dimension : user_num

-one expression =SUM({xxxxxx>}AGGR(amount,FACTURATION_NUM,user_num))

i want to save this value into a vairable to be able to user it in other charts that have others dimensions

how can i do that?

thanks in advance

[MK_QSL]

You can store as

Variable Name

vVariable

Value

SUM({xxxxxx>}AGGR(amount,FACTURATION_NUM,user_num))

Now use as below

$(vVariable)

[Anonymous]

no because the dimension is :

if(user_select = user_num, user_num)

and i checked the "supress when value is null " in the dimension.

do you have an other idea?

[avinashelite]

check this

Reusing Expressions

[MK_QSL]

Remove Calculated Dimension and implement that logic in Expression SET ANALYSIS

[Anonymous]

THANKS.

but at the end i just made :

=sum(if(user_num=user_select,aggr(SUM({xxxxxx>}AGGR(amount,FACTURATION_NUM,user_num)),user_num)))