topic I need help on Script in QlikView

I need help on Script

Mon, 23 Jun 2014 02:24:16 GMT

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,

Re: I need help on Script

Mon, 23 Jun 2014 02:26:24 GMT

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

Re: I need help on Script

Mon, 23 Jun 2014 02:38:59 GMT

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

Re: I need help on Script

sasikanth — Mon, 23 Jun 2014 04:46:21 GMT

Hi Venkat

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

Re: I need help on Script

Mon, 23 Jun 2014 04:53:40 GMT

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.

Re: I need help on Script

Mon, 23 Jun 2014 05:15:16 GMT

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);

Re: I need help on Script

sasikanth — Mon, 23 Jun 2014 05:21:06 GMT

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);

Re: I need help on Script

Tue, 24 Jun 2014 02:17:47 GMT

Thanks a lot for your help Guys.