i am new to qlik view and i am not able to achieve master calendar. I want to combine two data fields and make it as one.
actually i have 8 different date fields in my app, to over come synthetic key i am making alias for every field. But i want to combine all date fields as one date field.
Iam attaching one qvw file and excels , can any one tell me the process to do that.
in the app i want three fields to join as one date field.(date created in table1, RecDate in table2 and DateEntered in table3 needs to join to one date field)
Whey I your dates in the spreadsheets formatted like "mm:ss,0" ? If you re-format them into a date format like "DD/MM/YYYY", it would mike things much easier.
Try like below Canonical Date
i already reviewed that canonical date link but problem is i didnt understand the "OrderID2OrderDate" from this line
Load OrderLineID, Applymap('OrderID2OrderDate',OrderID,Null()) as CanonicalDate, 'Order' as DateType
where it comes from?
can u please make out the example
Anil, i don't have any relation to have canonical date field . So, i am little bit confused to follow that approach. can you suggest me any thing more
You have to do many applymaps over here because, You have to load many times and then concatenate by help of Canonical date due to single table has many date formats.
You want to make qvw from my end? If so, You may tell us what are the Date fields(i am expecting Date fields from each table) like that
Table1 : Field1, Field2, Field3
Table2: Field1, Field2, Field3
Table3: Field1, Field2, Field3
Note: Remind you i will make you by week-end. So, It's late night for me
can u make an example with qvw i have attached. below 3 columns are need to merged as one
table1 : date created,
table 2 : RecDate,
table3 : DateEntered
needs to join as one date field
I understood your sample but in that sample the year filter is not working . When i select 2017 or 2016 then then count becomes zero but in 2017 the count is 241 .
Can u please check and confirm.