Can i use dimension as expression

[rahulhv1]

Hi

Can we user dimension as expression . Below is the example.

I have an excel sheet as under

Name	Formula
rahul	=SUM(2+1)
vilas	=SUM(4+1)
santosh	=SUM(5+1)

I have pulled this in qlikview document. Now i have created a table chart and i want to use Fromula column as an expression so that the out put would be as under.

Name	Formula
rahul	3
vilas	5
santosh	6

[sergio0592]

Hi, try with :

LOAD

Name,

Evaluate(Formula) as Output_formula

FROM Data.xlsx

(ooxml,embedded labels, table is Sheet1);

[rahulhv1]

Thanks Jean for quick reply , but sorry to say, it isn't working

[rahulhv1]

Sorry, its working. But in the Formula column i wish to use Set analysis expression and that i want to use.

[Clever_Anjos]

You can´t reuse an expression of one object into another, but you can create a variable with your expression and use this variable into any charts needed

[rahulhv1]

Thanks for the reply. I can create the variables, but there are almost 150 expressions which i need to create to form a single table and creating these many variables is not suitable. I am creating a dash board which has many more KPI's like : Sales, Operations (OEE, OPE, IHR, COPQ), Raw material consumption, Variable costs, fixed costs, HR Related data and so on.  In addition to the actual values, i am having budgets of the same as well. Keeping this in mind , i wanted to write expressions in Excel file beside the KPI name , and use the same.

[Clever_Anjos]

It´s in portuguese, but the example can help you Qlikview utilizando Expressão com origem no Excel

[MarcoWedel]

please post a sample application including some data and expressions to test with.

thanks

regards

Marco

[vinieme12]

use the Only() function

Loading Expressions From File - WITHOUT creating variables in Script

[rahulhv1]

Thank you so much. Can i have the same in English, it will help me in understanding the logic.