topic Re: QlikView Master Calendar with diffrent Date sources in QlikView

QlikView Master Calendar with diffrent Date sources

Wed, 13 Feb 2013 15:03:21 GMT

Dear Community,

I did not find an answer to my question in the current Blog, so I hope someone can assist.

With my current application I've connection several tables with dates.

For example:

CRU Steel market

PLATTS Iron Ore

PLATTS Cocking Coal

etc.

For each table I've create:

- Monthname

- Year

- Month and so on....

After all the result is a synthetic key with Monthname, Year....

How can I create a master calendar over all tables? To reduce or avoid the synthetic key?

My thought are:

- Naming all Date Filed as $DATE

- Create a Monthname etc. on the linked $DATE....

Is that logical?

Thanks for support

BR Michael

Re: QlikView Master Calendar with diffrent Date sources

Gysbert_Wassenaar — Wed, 13 Feb 2013 17:46:29 GMT

Read this, this and this.

Re: QlikView Master Calendar with diffrent Date sources

Thu, 14 Feb 2013 10:25:09 GMT

Hi Gysbert,

thank you for the answer.

Unfourtanatly my problem is not fixed.

I like this thread.

http://community.qlik.com/thread/66717

But it means that I nead a primary keay in each table.

The tutorial from Hendric suggest a "own" Date for each Table.

That is something I dont want.

Each table has a own named Date field

Like:

HCCDate

IODEXDate

DollarDate

ScrapDate.

But I want one major table, like a concat. table for all dates.

Does it makes sense`?

Re: QlikView Master Calendar with diffrent Date sources

Thu, 14 Feb 2013 11:50:16 GMT

Hi Gysbert,

I found that:

http://community.qlik.com/message/274922#274922

That is what I want to do, but that does not work!?

If named my tables in a test simillar. See attached

TempCal:

Load

Date as CommonDate

from Daily sales

concatenate

I helped myself with a resident load. Is that correct?

I will add the QV Testfile.

Re: QlikView Master Calendar with diffrent Date sources

Gysbert_Wassenaar — Thu, 14 Feb 2013 12:16:44 GMT

Well, it worked. You now have a TempCal table that contains dates from your other tables. And it's not linked to your other tables so it's now a data island. That's the third scenario you could use. Select dates in your TempCal data island and use triggers to select the dates in your other tables. See attached examples.

Re: QlikView Master Calendar with diffrent Date sources

Thu, 14 Feb 2013 12:23:29 GMT

Dear Gysbert,

Thank you. You helped me a lot, with givin me the right clue.

Please find attached what I've done.

In the second step I will build you Calendar in.

Re: QlikView Master Calendar with diffrent Date sources

Fri, 25 Oct 2013 01:10:35 GMT

How you have triggered other dates with common date in "salestodate12.qvw" file.

Thank you.