topic Handle two dates from two tables in QlikView

Handle two dates from two tables

akpofureenughwu — Tue, 29 Aug 2017 05:23:09 GMT

Hello everyone,

Here is my sample data sets

Expenditure Table

Date	Location	Expenditure Item	Expenditure Figure (Naira) PER	Expenditure Figure (Naira) YTD
01/12/2012	Lagos	CAPEX	1,184.69	1,184.69
01/12/2012	Lagos	OPEX	5,544.16	5,544.16

Cash Call

Date	Location	Partner	Equity	PER NGN	YTD NGN
01/12/2012	Lagos	John	80	-3,450.98	-3,450.98
01/12/2012	Lagos	Fred	20	-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?

Re: Handle two dates from two tables

its_anandrjs — Tue, 29 Aug 2017 06:32:54 GMT

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

Canonical Date

Re: Handle two dates from two tables

effinty2112 — Tue, 29 Aug 2017 07:20:50 GMT

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

Re: Handle two dates from two tables

akpofureenughwu — Wed, 30 Aug 2017 07:48:59 GMT

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