Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Can any one help me regarding master calendar

Hi all,

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)

stevedarkloveisfailrwunderlichhichamswuehl

22 Replies
Creator II
Creator II

Hi,

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Contributor III
Contributor III

hi anil,

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

          Resident OrderLines;

where it comes from?

can u please make out the example

Contributor III
Contributor III

hi Filip Duchateau,

i have formatted date filed in the excel into dd-mm-YYYY. Please find the attachments.

Contributor III
Contributor III

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Contributor III
Contributor III

hi anil,

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

Check now.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Contributor III
Contributor III

Hi Anil,

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.