topic Re: How to use expressions in edit script? in QlikView

How to use expressions in edit script?

udaya_kumar — Thu, 29 Nov 2012 10:56:15 GMT

Hi,

I have huge expression to be calculated in the chart.

So everytime the object is active, it is calculating and it is giving performance issue.

So how can i use these expressions in edit script and then use simple expression in expression field in chart?

Can someone help me?

er_mohit — Thu, 29 Nov 2012 11:08:13 GMT

i didnt get u. what u exactly want .. so plz explain it briefly

Thu, 29 Nov 2012 11:43:45 GMT

plz explain it briefly

Peter_Cammaert — Thu, 29 Nov 2012 11:59:53 GMT

A quick reply before we get more details:

Precalculate what you can in Load script. Use aggregation tables where needed. Memory is cheaper than user patience.

Peter

udaya_kumar — Thu, 29 Nov 2012 12:01:14 GMT

I have very big expression in chart,

now for ex,

vSales = sum({$<Year = {$(=max(Year))}, Month = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} LineSalesAmount)

Consider this example,

here i want to use this expression in edit script instead of chart.

In chart, i need to make it very simple like

=vSales

in expression in the chart.

so that the calculations will be done in the edit script itself

udaya_kumar — Thu, 29 Nov 2012 12:02:46 GMT

Hi pcammaert,

Can you give me an example?

so that i can check it and try it.

Peter_Cammaert — Thu, 29 Nov 2012 12:05:02 GMT

What do you mean by "edit script"?

udaya_kumar — Thu, 29 Nov 2012 12:07:37 GMT

hi,

Edit script means, where we write load script or SQL select script.

the edit script window (Ctrl + E)