topic Re: how to link multiple dates to single calendar in QlikView

how to link multiple dates to single calendar

Tue, 23 Jun 2015 06:27:58 GMT

I have 5 different tables and each table has start_date and end_date. Need to link all these dates to the master calendar. Can someone please help me with this.

Regards

kumar

Re: how to link multiple dates to single calendar

jonathandienst — Tue, 23 Jun 2015 06:29:36 GMT

See Henric Cronstom's article on this topic: Canonical Date

Re: how to link multiple dates to single calendar

balasundaram — Tue, 23 Jun 2015 06:33:09 GMT

Hi,

do Link Table , based on start_date and end_date from all tables.

This is only best solution(LINK TABLE).

after give link to master calendar.

Regards,

Bala

Re: how to link multiple dates to single calendar

avinashelite — Tue, 23 Jun 2015 06:44:45 GMT

Hi Raman,

Create a link table to include all the dates .

Link table will best option.

e.g

master:

Load id,

createdate,

enddate

Select SQl;

link table:

load id,

createdate as date

resident

master;

load id,

enddate as date

resident

master;

calender:

load

date,

.........

SQL;

Re: how to link multiple dates to single calendar

abhaysingh — Tue, 23 Jun 2015 06:55:02 GMT

Hi Kumar,

You can do one thing Suppose you have 5 transaction table's and five different dates in it.. Name them same name suppose link_date and concatinate all 5 table on the basis of link_date. and create your master calender as per link date.

Tab1;

load

Date1 as link_date,

field1

from.....

concatenate

Tab2:

load

Date2 as link_date,

field2

from...

concatenate

Tab3:

load

Date3 as link_date,

field3

from....

and so on for all transaction TABLE.

thanks

abhay

Re: how to link multiple dates to single calendar

Tue, 23 Jun 2015 07:07:18 GMT

GOOD

Re: how to link multiple dates to single calendar

vardhancse — Tue, 23 Jun 2015 07:15:03 GMT

Yes, we can do using link table. But issue is that each record will be multiplied by the number of tables.

If the data is very huge it may impact the performance, instead creating 3 separate calendars may also work.it depends on the data volume to the dashboard

Re: how to link multiple dates to single calendar

Tue, 23 Jun 2015 08:28:35 GMT

Thanks everyone for your response much appreciated.

I used link table and everything is working fine.

Regards

kumar.R

Re: how to link multiple dates to single calendar

avinashelite — Tue, 23 Jun 2015 10:04:02 GMT

Hi Raman,

If you have got the answer please mark it as correct answer and close this thread