topic Call a Calculated Expression Name from another object in QlikView

Call a Calculated Expression Name from another object

Anonymous — Fri, 07 Mar 2014 14:50:54 GMT

I am creating a pie chart and i only want to use one expression. I was wondering if i can call an expression from another object, so instead of using GetObjectField which only pulls the fields from the Dimension, is there any other command i can use to call a calculated expression name instead?

Re: Call a Calculated Expression Name from another object

Gysbert_Wassenaar — Fri, 07 Mar 2014 14:56:14 GMT

No, that's not possible. What you do instead is create a variable and put the expression you want to reuse in that variable. Then you can use the variable instead.

Variable vMySum: sum(Sales)

Expression in chart A: $(vMySum)

Expression in chart B: $(vMySum)*100/count(Region)

Re: Call a Calculated Expression Name from another object

SunilChauhan — Fri, 07 Mar 2014 15:04:16 GMT

You can call a calculated Expression name in Same Object Expression. but That name Cannot be used in another AppLication.

You can do one the thing You can write that Expression in Script and use that field where ever you Want.

else variable is another way

Re: Call a Calculated Expression Name from another object

Anonymous — Fri, 07 Mar 2014 15:06:49 GMT

I guess I will try that, thanks for the quick response

Anthony Gonzalez

CHEP

Senior Customer Controls & Intelligence Analyst

Sales

+1 407 355 6525 Work

Anthony.Gonzalez@chep.com<mailto:Anthony.Gonzalez@chep.com>

8517 South Park Circle

Orlando, FL 32819