topic Re: Two calendars in one chart in QlikView

Two calendars in one chart

vchuprina — Thu, 06 Apr 2017 16:07:01 GMT

Hi,

I'm trying to combine two tables with different calendars into one chart.

Tables are linked by item code and I created link table with following fields:

DateLink:

LOAD
[ItemKey] AS ItemKey,
TransDateKey as Date,
'Trans' AS DateType
Resident Trans;

LOAD
[ItemKey] AS ItemKey,
OperDateKey as Date,
'Operations' AS DateType
Resident Operations;

And the problem that I can't correctly load data.

When I load Item and TransDateKey from Trans table I have 120 items for 2017-04-06

But when I load data with DataLink table I chose DateType Trans and get another results, for some reason I get 2481 item.

At the moment I cant understand what is wrong.

Re: Two calendars in one chart

Anil_Babu_Samineni — Thu, 06 Apr 2017 16:13:00 GMT

Try with Join Condition for two tables.

LOAD
[ItemKey] AS ItemKey,
TransDateKey as Date,
'Trans' AS DateType
Resident Trans;

Join

LOAD
[ItemKey] AS ItemKey,
OperDateKey as Date,
'Operations' AS DateType
Resident Operations;

Re: Two calendars in one chart

vchuprina — Thu, 06 Apr 2017 16:20:04 GMT

I have the same result

Re: Two calendars in one chart

vishsaggi — Thu, 06 Apr 2017 16:21:24 GMT

Can you share your data model?

Re: Two calendars in one chart

Anil_Babu_Samineni — Thu, 06 Apr 2017 16:21:39 GMT

May be share sample application it demonstrates the issue

Re: Two calendars in one chart

vchuprina — Thu, 06 Apr 2017 16:39:56 GMT

Re: Two calendars in one chart

Anil_Babu_Samineni — Thu, 06 Apr 2017 16:47:19 GMT

May be helpful -- Canonical Date