topic Re: Master calendar without linking tables in QlikView

Master calendar without linking tables

Sun, 27 Jan 2013 22:06:16 GMT

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

Re: Master calendar without linking tables

khadeer — Mon, 28 Jan 2013 04:40:05 GMT

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.

Re: Master calendar without linking tables

Mon, 28 Jan 2013 10:57:55 GMT

Hi,

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

Re: Master calendar without linking tables

khadeer — Mon, 28 Jan 2013 11:07:36 GMT

Hi PFA.

Re: Master calendar without linking tables

Mon, 28 Jan 2013 11:20:28 GMT

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

orderid	Orderdate	ApprovedDate	CancellatioDate	ReturnDate	Amount
1	09.11.2012	25.11.2011	-	02.12.2012	10,00
2	15.11.2012	-	01.12.2012	-	35,00
3	18.11.2012	03.12.2012	-	05.01.2013	80,00
4	12.12.2012	18.12.2012	-	02.01.2013	140,00
5	15.12.2012	06.01.2013	18.01.2013	-	65,00
6	05.01.2013	08.01.2013	-	03.02.2013	15,00
					345,00



Requested Table	November	December	January	February	Total
Orders	125,00	205,00	15,00		345,00
Approved Orders	10,00	220,00	80,00		310,00
Cancelled Orders		35,00	65,00		100,00
Return Orders		10,00	220,00	15,00	245,00

Re: Master calendar without linking tables

Mon, 28 Jan 2013 19:18:37 GMT

Any idea??

Re: Master calendar without linking tables

Anonymous — Mon, 28 Jan 2013 20:37:04 GMT

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

Re: Master calendar without linking tables

Mon, 28 Jan 2013 21:39:27 GMT

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

rwunderlich — Mon, 28 Jan 2013 22:54:20 GMT

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