Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

akpofureenughwu
Contributor 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

Re: Handle two dates from two tables

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

Canonical Date

effinty2112
Honored Contributor

Re: Handle two dates from two tables

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
Contributor III

Re: Handle two dates from two tables

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