topic Re: Automating the expression in QlikView

Automating the expression

rash_611 — Fri, 04 Dec 2015 11:59:32 GMT

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,

Re: Automating the expression

jonathandienst — Fri, 04 Dec 2015 12:10:28 GMT

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

Re: Automating the expression

jonathandienst — Fri, 04 Dec 2015 12:11:42 GMT

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)

Re: Automating the expression

rash_611 — Fri, 04 Dec 2015 12:15:16 GMT

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

Re: Automating the expression

rash_611 — Fri, 04 Dec 2015 12:20:59 GMT

how to call this in the textbox

Re: Automating the expression

jonathandienst — Fri, 04 Dec 2015 12:23:03 GMT

>>how to call this in the textbox

Now use the created variables as expressions:

=$(Logged)

=$(Closed)

Re: Automating the expression

Fri, 04 Dec 2015 12:35:00 GMT

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.