Automating the expression

[rash_611]

Hi Team,

I have an excel as below. Instead of writing expression in each textbox or in chart i want to use this excel and automate the expression.

Kindly help me.

KPI	Expression
Logged	COUNT(DISTINCT {$<Process={'XYZ'}>} ID)
Closed	COUNT(DISTINCT {$<Status={'Closed'}, Process={'XYZ'}>} ID)

Regards,

GR

[jonathandienst]

Please provide more detail on what you mean by 'automating' the expression?

[jonathandienst]

Do you mean you want to load the expression from the spreadsheet?

T_Expressions:

LOAD KPI,

     Expression

FROM Expressions.xlsx (...)

For i = 0 To NoOfRows('T_Expressions')

     Let zkpi = Peek('KPI', i, 'T_Expressions');

     Let zexpr = Peek('Expression', i, 'T_Expressions');

     Set $(zkpi) = zexpr;

Next

Now use the created variables as expressions:

     =$(Logged)

     =$(Closed)

[rash_611]

i have 5 text box and 4 chart to show the logged value and 3 text box and 6 charts to show closed values. Instead of writing the expression in all the charts & textbox. i want to automate this. is this possible

[rash_611]

how to call this in the textbox

[jonathandienst]

>>how to call this in the textbox

Now use the created variables as expressions:

     =$(Logged)

     =$(Closed)

[#7]

Hi,

I have implemented a simple example having some values for process and status.Its working for me. But depends on the complexity of your requirement.

Please find the attached QVW.