Discussion Board for collaboration on QlikView Scripting.
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.
Try with Join Condition for two tables.
LOAD [ItemKey] AS ItemKey,TransDateKey as Date, 'Trans' AS DateTypeResident Trans;
LOAD [ItemKey] AS ItemKey,OperDateKey as Date, 'Operations' AS DateTypeResident Operations;
I have the same result
Can you share your data model?
May be share sample application it demonstrates the issue
May be helpful -- Canonical Date