topic Re: Expression in QlikView

Expression

adiarnon — Thu, 16 Mar 2017 12:02:04 GMT

hi,

i have this expression-

=$(='COUNT({<Division={"=Aggr(Sum({<METRIC=,COMPONENETID={''49''}>}COMPONENTVALUE)/Sum({<METRIC=,COMPONENETID={''50''}>}COMPONENTVALUE)*100,Division)'&Metric_Red&'"}>}DISTINCT Division)')

and i have a varialbe

v_formula=Sum({<METRIC=,COMPONENETID={'49''>}COMPONENTVALUE)/Sum({<METRIC=,COMPONENETID={'50'}>}COMPONENTVALUE)*100

i need to to use the expression but to replace the expression in the aggr with the variable.

i have a problem with all the ' and "...

how can i do it?

adi

Re: Expression

marcus_sommer — Thu, 16 Mar 2017 15:49:21 GMT

Try this:

COUNT({<Division={"=Aggr($(v_formula)&'Metric_Red&'"}>}DISTINCT Division)

- Marcus

Re: Expression

Anonymous — Thu, 16 Mar 2017 17:09:27 GMT

just a question:

why is =aggr(..., Division) needed?

I think we're anyway within dimension "Division" or am I wrong?

found the answer --> nested aggregation

Re: Expression

adiarnon — Mon, 20 Mar 2017 06:57:26 GMT

tnx' but i have in the begining - =$(='

so i have a problem with the '

adi

Re: Expression

marcus_sommer — Mon, 20 Mar 2017 07:32:26 GMT

Maybe this one:

COUNT({<Division={"=chr(39) & Aggr($(v_formula),Division) &'Metric_Red&' & chr(39)"}>}DISTINCT Division)

- Marcus