Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

retrieving data from excel & hav to match with the records from qvd

Hi Experts,

      i hav attached an excel sheet which has some promotion details. this sheet going to get updated weekly.

i hav the following tables from qvd.

Tab_Name:

LOAD BRH,

     DATE(DEC, 'DD/MM/YYYY') AS SDATE,

     MONTH(DEC) AS BMONTH,

      YEAR(DEC) AS BYEAR,

     Name,

     PNo,

     Des,

     Sales,

     Quantity

FROM

[QVD\ Tab_Name.qvd]

(qvd);

Concatenate

Tab2:

LOAD ACC_CODE,

     BCODE,

     BNAME as Branch,

     SORDER

FROM

[QVD\ Tab2.qvd]

(qvd);

Now, when i select a particular date, the report ll display the details of the above tables. also it should check the details of the excel sheet  for the same date & any data found, report should display that details too.

wat may be the solution for this requirement. please help me in this regard asap.

7 Replies
Not applicable
Author

You should use intervalmatch() for this.

Use this thread for guidance IntervalMatch function

Not applicable
Author

Hi PRRAJENDRAN,

As per your script stated above ther is no two matching date fileds in Qvd and excel.

I assume you need to reame the excel file date fileds. Then only you can see the report from both tables.

neetha_p
Master
Master

Hi Rajendran

Please use interval match function.

//Try below code in script

WeeklyUpdate:
LOAD Week,
    
StartDate,
    
EndDate,
    
PartNo,
    
Description
FROM

(
biff, embedded labels, table is Sheet1$);

Tab_Name:
LOAD BRH,
    
DATE(DEC, 'DD/MM/YYYY') AS SDATE,
    
MONTH(DEC) AS BMONTH,
    
YEAR(DEC) AS BYEAR,
    
Name,
    
PNo,
    
Des,
    
Sales,
    
Quantity
FROM [QVD\ Tab_Name.qvd](qvd);

Concatenate

LOAD ACC_CODE,
    
BCODE,
    
BNAME as Branch,
    
SORDER
FROM [QVD\ Tab2.qvd](qvd);


Left join(Tab_Name)

Intervalmatch(SDATE)
LOAD StartDate,EndDate
RESIDENT WeeklyUpdate;

Left join (Tab_Name)

LOAD Week,
    
StartDate,
    
EndDate,
    
PartNo,
    
Description
Resident WeeklyUpdate;

drop table WeeklyUpdate;

Regards

Neetha

Not applicable
Author

thank u very much Neetha.

ll try this script.

rajkumarb
Creator II
Creator II

HI PR

Instead of Using Interval Match You can Use Reference Dates for Interval dates,

Go through the following Link

Creating Reference Dates for Intervals

Not applicable
Author

sorry neetha. its not working.

any other suggestions..pls

neetha_p
Master
Master

Hi Rajendran,

Please can you upload QVD file or part of data,so can help.

Regards

Neetha