Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master
Master

How to make my exchange rate table date link with my master calendar ?

Hi All

My below script no error :-

// Section 1 Load exchange table
RATE:
LOAD SOURCE,
Currency,
Rate,
Date(date_t, 'D/M/YYYY') as date,
Date(date_t, 'D/M/YYYY') as date_RATE,
Rate_,
date_t
FROM
[Map_Rate.xlsx]
(ooxml, embedded labels, table is Sheet);

// Section 2 Load sales table
sales:
LOAD
Date#(date_inv, 'D/M/YYYY') AS date,
LineSalesAmount,
profit_amt,
inv_no,
BRAND,
company,
SOURCE,
sbu,
ODSE

INLINE [date_inv, LineSalesAmount,profit_amt,inv_no,BRAND,company,sbu,ODSE,SOURCE
14/1/2020, 30,4,1235 ,YASKAWA,JCS,AP_SBU,AP,TDT
14/2/2020, 10,4,1235 ,YASKAWA,JCS,AP_SBU,AP,TDT
];


My issue is Rate Table date field not able to link to master calendar table.

Hope some one can advise me.

Paul

2 Replies
Highlighted
Master
Master

Re: How to make my exchange rate table date link with my master calendar ?

My QVW and Rate table

Highlighted
Master
Master

Re: How to make my exchange rate table date link with my master calendar ?

Hi All

I just try to modify the sales table date to below :-

INLINE [date_inv, LineSalesAmount,profit_amt,inv_no,BRAND,company,sbu,ODSE,SOURCE
1/1/2020, 30,4,1235 ,YASKAWA,JCS,AP_SBU,AP,TDT
1/2/2020, 10,4,1235 ,YASKAWA,JCS,AP_SBU,AP,TDT
];

Which is same as my Exchange table date , then it work fine.

But in actual fact the date cannot be same.

Paul Yeo