I need help on Script

[#1]

I am new to Qlikview and how to push the values into the script and i attached my .QVW file.

Thanks for the help

Advance,

[#2]

sorry what do you mean when you say "push"?

[#3]

Sorry I confused before.I have ATP chart  and i have one week loss Units and one week loss Dollars in my expression

how can i calculate the values of  expressions script it self.

Thanks for the Help in Advance

[sasikanth]

Hi Venkat

Didn`t get your requirement , can you plese explain us a bit briefly ...

[#5]

Hi SasiKanth,

                         As i mention above i have different expressions in my chart.My question was how to put the those expressions in to my Script editor.

Thanks for the help,

Advance.

[#6 · Accepted solution]

Hi,

Add the below script on top of your FACT load as preceding load.

Load *,

if(IATP<Day7Forecast,IATP-Day7Forecast,0) as [1 Wk loss Units],

if(IATP<Day7Forecast,(IATP-Day7Forecast)*Avg12MonthsSalesPrice,0) as [1 Wk loss Dollers];

LOAD CONO&ITNO as Item_Key,

CONO as Company,

     DIVI as Division,

     WHLO as Warehouse,

     //Warehouse,

     StyleSizeColor,

     Style  as Style_FACT,

     Size AS Size_FACT ,

     Color,

     [Make/Buy Code] as Make_buy_FACT,

     PFence,

     LTime,

     PctTTM,

     SizeRank,

     ATPDate,

     ITNO,

     STQT,

     ALQT,

     IATP,

     ADFI,

     Avg12MonthsSalesPrice,

     Avg12MonthSalesQtyPerSale,

     CurrentForecast,

     Day7Forecast,

     Day14Forecast,

     Day21Forecast,

     Day28Forecast,

     Day56Forecast,

     Day84Forecast,

     Day112Forecast

FROM

[..\..\QVD\ATP\ATPFuture.qvd]

(qvd);

[sasikanth]

hi

if you are calculating values based on the fields that are from diffrent tables then you cannot calculate these expressions in script unless if you go for concatinate or join

if from same table , then

TAB:

LOAD

"your expresssion" as <Alias-name>,

"your expression" as <Alias-name>,

.

.

.

.

From ....................................

..................................(qvd);

[#8]

Thanks a lot for your help Guys.