topic Re: implement expression in script level in QlikView

implement expression in script level

gauthamchilled — Tue, 14 Jul 2015 03:00:35 GMT

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

Re: implement expression in script level

robert_mika — Tue, 14 Jul 2015 03:41:39 GMT

Can you add screenshot as well?

Some of us are working on PE .

Re: implement expression in script level

gauthamchilled — Tue, 14 Jul 2015 03:52:39 GMT

Sure..PFA

Re: implement expression in script level

gauthamchilled — Tue, 14 Jul 2015 04:29:43 GMT

Any help?

Re: implement expression in script level

settu_periasamy — Tue, 14 Jul 2015 04:38:59 GMT

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

Re: implement expression in script level

gauthamchilled — Tue, 14 Jul 2015 04:42:20 GMT

Yes, it changes dynamically.

Re: implement expression in script level

vikasmahajan — Tue, 14 Jul 2015 04:43:05 GMT

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

Re: implement expression in script level

maxgro — Tue, 14 Jul 2015 04:45:22 GMT

PFA

Re: implement expression in script level

robert_mika — Tue, 14 Jul 2015 04:45:27 GMT

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...

Re: implement expression in script level

gauthamchilled — Tue, 14 Jul 2015 04:46:02 GMT

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

Re: implement expression in script level

gauthamchilled — Tue, 14 Jul 2015 05:11:46 GMT

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?

Re: implement expression in script level

gauthamchilled — Tue, 14 Jul 2015 05:25:15 GMT

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?