topic Re: Script loading in QlikView

Script loading

vikasmahajan — Thu, 11 Oct 2012 11:07:09 GMT

Dear all

I have following script with stockinoutindicator field while loading data from qvd now I want to give following

Condition

============================

(Today()-max([Posting Date])) as [Exp Days Items]

where StockInOutIndicator = '1'

============================

in same qvd file how to achive this can any one help in this matter.

Script

=============================

ValueEntry_IAL:

LOAD

if([Valued Quantity] >= 0

AND

((Entry_Type = 0 AND Doc_Type = 5)

OR (Entry_Type = 1 AND Doc_Type = 3)

OR (Entry_Type = 2)

OR (Entry_Type = 4 AND Doc_Type = 10)

OR (Entry_Type = 4 AND Doc_Type = 0)

OR (Entry_Type = 6)),1,0) AS StockInOutIndicator

FROM

[Source QVDs NAV\Value_Entry.qvd]

(qvd);

Re: Script loading

Miguel_Angel_Baeyens — Thu, 11 Oct 2012 11:16:50 GMT

Hi,

You can use a preceding load, something like:

ValueEntry_IAL:
LOAD *,
   If(StockInOutIndicator = 1, Today() - Max([Posting Date])) AS [Exp Days Items];
LOAD
   IF([Valued Quantity] >= 0
   AND
     ((Entry_Type = 0 AND Doc_Type = 5)
   OR (Entry_Type = 1 AND Doc_Type = 3)
   OR (Entry_Type = 2)
   OR (Entry_Type = 4 AND Doc_Type = 10)
   OR (Entry_Type = 4 AND Doc_Type = 0)
   OR (Entry_Type = 6)),1,0) AS StockInOutIndicator,
  ... // rest of the fields here
FROM
   [Source QVDs NAV\Value_Entry.qvd]
   (qvd);

Hope that helps.

Miguel

Re: Script loading

vikasmahajan — Thu, 11 Oct 2012 11:18:38 GMT

Thanks for prompt reply I will get back you.

Re: Script loading

jagannalla — Thu, 11 Oct 2012 11:31:53 GMT

Miguel,

I think Max function will not work while loading with other fields without GroupBy.

Vikasmahajan,

The below code will help you, but make sure Today()-$(vMaxPD) should me in same format

MaxPDTable:
LOAD
max([Posting Date]) as MaxPD
FROM
[Source QVDs NAV\Value_Entry.qvd]
(qvd);
LET vMaxPD = Peek('MaxPD',-1,'MaxPDTable');
ValueEntry_IAL:
LOAD *,(Today()-$(vMaxPD)) as [Exp Days Items]
Where StockInOutIndicator=1;
LOAD *,
if([Valued Quantity] >= 0
   AND
     ((Entry_Type = 0 AND Doc_Type = 5)
   OR (Entry_Type = 1 AND Doc_Type = 3)
   OR (Entry_Type = 2)
   OR (Entry_Type = 4 AND Doc_Type = 10)
   OR (Entry_Type = 4 AND Doc_Type = 0)
   OR (Entry_Type = 6)),1,0) AS StockInOutIndicator
FROM
[Source QVDs NAV\Value_Entry.qvd]
(qvd)
;

Cheers!!

Jagan

Re: Script loading

vikasmahajan — Fri, 12 Oct 2012 03:12:26 GMT

you are wright...

Thanks Mr.Jagan I will try let you know the status...

Vikas

Re: Script loading

vikasmahajan — Fri, 12 Oct 2012 07:46:19 GMT

I have attached QV1.qvw file , Please it is loading only 3 records who have

StockInOutIndicator = 1 , but i want all the 4 records load all data with exp days.

Please reply

Thanks

Vikas

Re: Script loading

jagannalla — Fri, 12 Oct 2012 09:01:48 GMT

Hello,

Can you attach sample data file(i.e. xyz.qvd).

Thanks,

Jagan

Re: Script loading

vikasmahajan — Fri, 12 Oct 2012 09:20:50 GMT

I have attached the qvd ,

pls reply.

Re: Script loading

jagannalla — Fri, 12 Oct 2012 10:11:55 GMT

Sorry I didn't seen Inline table. Ok see this image

For max date your StockInOutIndicator gives you zero value. When we are loading the table with condition Where StockInOutIndicator we can see only 3 records.

Cheers!!

Jagan

Re: Script loading

vikasmahajan — Fri, 12 Oct 2012 10:21:52 GMT

cAN WE SHOW ALL 4 RECORDS AT A TIME ?

Re: Script loading

vikasmahajan — Fri, 12 Oct 2012 10:37:32 GMT

cAN WE SHOW ALL 4 RECORDS AT A TIME ?

Re: Script loading

jagannalla — Fri, 12 Oct 2012 10:43:35 GMT

Then we need to remove the where conditon...

Re: Script loading

vikasmahajan — Sat, 13 Oct 2012 10:48:59 GMT

Jagan 41193 days appering insted of 73 ? what could be a reson

Re: Script loading

jagannalla — Tue, 16 Oct 2012 08:41:06 GMT

How are you saying that you need 73 ?

It all depends on what we need. Can you attach sample file according to your data what you have now and tell us wt is the output you need according to that data.

Cheers!!

Jagan