Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
akpofureenughwu
Creator III
Creator III

Handle two dates from two tables

Hello everyone,

Here is my sample data sets

Expenditure Table

    

DateLocationExpenditure ItemExpenditure Figure (Naira) PERExpenditure Figure (Naira) YTD
01/12/2012LagosCAPEX1,184.691,184.69
01/12/2012LagosOPEX5,544.165,544.16

Cash Call

    

DateLocationPartnerEquityPER NGNYTD NGN
01/12/2012LagosJohn80-3,450.98-3,450.98
01/12/2012LagosFred20-1,607.60-1,607.60

The expenditure table shows the expenditure made on loca

In the above tables, to eliminate synthesis keys I used location and rename l date in cash call table to cashdate.

My questions are

1. Can I merge the two dates together while location is the primary key in this design?

3 Replies
its_anandrjs

You have to use Canonical Dates please read the thread of the HIC

Canonical Date

effinty2112
Master
Master

Hi Akpofure,

                         You can give your date fields different names and have two separate master calendars which is the simplest solution. However if you plan on charting Cash Calls and Expenditure together against a common date dimension then a canonical calendar is necessary.

Kind regards

Andrew

akpofureenughwu
Creator III
Creator III
Author

Hello sir,

Can you explain this script below:

Orders:

LOAD *, 1 as OrderCounter INLINE [

OrderId, OrderDate, Quantity

1, 01/01/2012, 101

2, 01/01/2012, 102

3, 02/01/2012, 103

4, 03/01/2012, 104

5, 03/03/2012, 105

6, 03/04/2012, 106

]

;

I got it from this link : Linking to two or more dates