topic Manage frequently used expressions in script editor in QlikView

Manage frequently used expressions in script editor

dpietersz — Wed, 30 Dec 2009 20:48:01 GMT

I have the following code in my script:

SET eYTD = 'sum({$<Year = {$(=max(Year))}, Month = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} LineSalesAmount)';

I want to use "eYTD" in my charts as an expression. But after a reload the content of "eYTD" is:

sum({$<Year = {(internal error)}, Month = {"<=(internal error)"}>} LineSalesAmount)

Any suggestion?

Manage frequently used expressions in script editor

Wed, 30 Dec 2009 22:48:47 GMT

First, you want to use Let instead of Set. Then in your expressions, replace all of the dollar signs with:

' & Chr(36) & '

So:

LET eYTD = 'sum({' & Chr(36) & '<Year = {' & Chr(36) & '(=max(Year))},
Month = {"<=' & Chr(36) & '(=max({<Year={' & Chr(36) & '(=max(Year))}>} Month))"}>} LineSalesAmount)';

Then once you reload, QlikView will put in the dollar signs, but not evaluate the dollar sign expansion. Your variable should contain the Set Analysis expression and it should work in your charts.

Manage frequently used expressions in script editor

dpietersz — Mon, 04 Jan 2010 18:19:25 GMT

It worked.

Thx NMiller!

Re: Manage frequently used expressions in script editor

udaya_kumar — Thu, 29 Nov 2012 10:30:59 GMT

Hi Dimitri and NMiller,

How you have used the eYTD field in your expressions in chart?

I used it like

I gave just =eYTD in the expression in the chart,

the table is showing the whole expression instead of evaluating that expression.

so how to use that eYTD in expression in chart?

Can you please help me?