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

[robert_mika]

Can you add screenshot as well?

Some of us are working on PE .

[gauthamchilled]

Sure..PFA

[gauthamchilled]

Any help?

[settu_periasamy]

Hi Goutham,

Do you want the calculation for your mentioned month?  (Mar' 09, Jun'09 and Quarter Mar'09)

or is that change dynamically like

Mar'09 = Feb' 09 + Mar'09

Apr' 09 = Mar'09 + Apr'09

...

like this

[gauthamchilled]

Yes, it changes dynamically.

[vikasmahajan]

Hii,

For your example you can not hard code years in expression formula , you need to implement calendar in qlikview and link this calender with facts and write in expression levels formula's

HTH

Vikas

[maxgro]

PFA

!

[robert_mika]

For your Monhly Average:

t1:

LOAD Sales,

     Month,

     Product,

     Period1

     FROM

(ooxml, embedded labels, table is Sheet1);

;

t2:

load

Period1,

Sum(Sales) as MSales

Resident t1

Group by Period1;

t3:

load

Period1,

(MSales+Previous(MSales))/LEFT(MonthEnd(Date(Period1,'DD-MM-YYYY')),2) as Average

Resident t2;

The Q total are on the way...

[gauthamchilled]

Yes, I don't want to hard code and use it in script level. can you help me how to do that?