topic what is the wrong in this script in QlikView

what is the wrong in this script

Wed, 22 Jul 2015 07:08:10 GMT

Hi I have a problem In the script, below

LOAD *,
(if(Unit= Previous(Unit),previous(sales), 0)) as PREV_sales;
LOAD *
Resident Temp_Data
Order By DATE,Unit;;

the above script is not returning any previous value for that unit where I gone wrong, can any one help me on this.

for sample data PFA.

Regards

John

Re: what is the wrong in this script

Ralf-Narfeldt — Wed, 22 Jul 2015 07:12:30 GMT

Field names are case sensitive, so you need to refer it as Unit in all places.

Re: what is the wrong in this script

qlikmsg4u — Wed, 22 Jul 2015 07:16:52 GMT

Original field names are Unit and Sales but you refer as unit and sales (Check Case Sensitive)

Try this

LOAD *,
(if(Unit= Previous(Unit),previous(Sales), 0)) as PREV_sales;
LOAD *
Resident Temp_Scott_Mileage_Data
Order By DATE,Unit;;

Re: what is the wrong in this script

vardhancse — Wed, 22 Jul 2015 08:30:09 GMT

Scott_Mileage_Data:

LOAD *,
(if(Unit= Previous(Unit),previous(Sales), 0)) as PREV_sales;
LOAD *
Resident Temp_Scott_Mileage_Data
Order By DATE,Unit;

Drop Table Temp_Scott_Mileage_Data;

Re: what is the wrong in this script

sasiparupudi1 — Wed, 22 Jul 2015 10:54:08 GMT

Hi John

As others have already mentioned, please check the case of your field names in the script.. Have you managed to resolve your problem?

Sasi

Re: what is the wrong in this script

qlikviewwizard — Wed, 22 Jul 2015 11:01:43 GMT

Hi Use this script.

Issue is with sales. Change to Sales.

Data:

LOAD *,

(if(Unit= Previous(Unit),previous(Sales), 0)) as PREV_sales;

LOAD Branch,

Unit,

Month,

Sales,

Year,

Month1

FROM

Data.xlsx

(ooxml, embedded labels, table is Sheet1);

Re: what is the wrong in this script

Wed, 22 Jul 2015 14:38:44 GMT

I got the answer. Thanks All.

Re: what is the wrong in this script

qlikviewwizard — Wed, 22 Jul 2015 14:40:35 GMT

johnDawson

Could you select correct answer and Helpful as you selected your comment.

Thank you.