implement expression in script level

[gauthamchilled]

hi

I have attached a file and I mentioned the formula and sample data in the file. can any one help me in implementing in script level. because if I do this in the chart expression it is resource heavy.  plz help

Thanks

Gautham

[gauthamchilled]

Hi Massimo,

Thanks for the response.

Actually I want to use this in an expression.

Eg:

sum({<MCD = {'500'}, Month=,Year=,DATE={">=$(vPriorMonth)<=$(vCurrentMonth)"},B_Type={'Avgl'}}>}Sales/2)*only(no of month days)

Above is the one which I am using in current expression which calculates (current month +previous month)/2 * no of month days.

I want to calculate this in script itself..bcuz every month i want to calculate like this...so can you help me how i can I achieve the above?

[gauthamchilled]

the expression I used easy for month level calc..but if I go and calculate for quarter and year..i have to take average and multiply for several months in expression.

is there anyway to avoid this resource heavy expression in chart and handle in qlikview script itself?