Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Master calendar without linking tables

Hi there,

I am newbie here and need some help.. I have multiple date fields, talking bout 30 different date fields in several huge tables, and i need to use them all in our budget table.

I vs tried to concatenat them bu there is too much data and difficult to manage them.. Is it possible create a unlinked calendar and then use that calendar with variables to display the data in a table/pivot chart?

Please check the example qvw and help))):

Thanks in advanced..

8 Replies
khadeer
Specialist
Specialist

If u have 30 date fields, i think there is one r two major date fields, give the association any one of them with master calander date field. It will work for all.

Not applicable
Author

Hi,

It doesnt work or i couldnt do it.. Could you please send me a qvw?

khadeer
Specialist
Specialist

Hi PFA.

Not applicable
Author

Thanks for the document but i doesnt help me. Probably i couldnt explain my problem..

When i link my order date, as major data, with master calendar, i can not show the orders cancelled yesterday.. I can only show the orders made yesterday and cancelled at any time..

below you can find an example..

orderidOrderdateApprovedDateCancellatioDateReturnDateAmount
109.11.201225.11.2011-02.12.201210,00
215.11.2012-01.12.2012-35,00
318.11.201203.12.2012-05.01.201380,00
412.12.201218.12.2012-02.01.2013140,00
515.12.201206.01.201318.01.2013-65,00
605.01.201308.01.2013-03.02.201315,00





345,00















Requested TableNovemberDecemberJanuaryFebruaryTotal
Orders125,00205,0015,00 345,00
Approved Orders10,00220,0080,00 310,00
Cancelled Orders 35,0065,00 100,00
Return Orders 10,00220,0015,00245,00
Not applicable
Author

Any idea??

Anonymous
Not applicable
Author

If you have one Master Calendar, it can be linked to one of the dates.  So, the question is - what you expect to see by selecting January 2013?  Created orders? Cancelled orders?
There are several ways to deal with it, depending on what you actually need.  For example, create separate calendars for OrderDate, ApprovedDate, etc.  Or, create on calendar not conected to anything, and use logic in expressions, comparing any type of date (for example by set analysis) with the selected in calendar.

Regards,
Michael

Not applicable
Author

Hello Michael, thanks for your answer.

Actually i should be able to see both.

I ve tried to do the second option, calendar not connected to anything.. and that s where i need help.. As you can see from my sample data, my variable doesnt work.. and dont know why...

Best regards..

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Take a look at the tutorial "Using Common Date Dimensions and Shared Calendars " at http://robwunderlich.com/tutorials/.

The tutorial will show you how to connect multiple date fields into common time dimensions, like month and week.

-Rob

http://robwunderlich.com