Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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_sparks
Valued Contributor

Re: Master calendar without linking tables

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

Re: Master calendar without linking tables

Hi,

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

khadeer_sparks
Valued Contributor

Re: Master calendar without linking tables

Hi PFA.

Not applicable

Re: Master calendar without linking tables

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

Re: Master calendar without linking tables

Any idea??

mov
Esteemed Contributor III

Re: Master calendar without linking tables

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

Re: Master calendar without linking tables

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..

Re: Master calendar without linking tables

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

Community Browser