topic Need a help to create a Master calender in QlikView

Need a help to create a Master calender

Fri, 15 Jun 2012 12:28:25 GMT

Dear,

Community.

I need a help in creating Master calender.

I have 4 main Tables

1) Organization

2)People

3)Subject

4)Report

one Fact table

all the main tables are connceted by fact table.

kindly find the atachement .

and all the main tables contains Date Field , so now i want to create a master calender which contain all the dates from all the tables.

Can i use DateIsland ?

thanks,

mukram.

Re: Need a help to create a Master calender

Fri, 15 Jun 2012 13:19:03 GMT

Dear,

Community Members

Is their any possibility to keep to calender separate without linking to the model.

but when ever i select like year 2012 i should show all the dataRelated of that Year,

Thanks,

Mukram.

Re: Need a help to create a Master calender

giakoum — Fri, 15 Jun 2012 13:41:08 GMT

use attached file to create a calendar. Not developed by me, it is available in the community.

use different names in calendar than in tables for the same field (i.e Year could be CalendarYear in calendar) and then set analysis to make the association for example :

sum({<[Year]=[CalendarYear]>} [Sales])

Re: Need a help to create a Master calender

Fri, 15 Jun 2012 15:22:58 GMT

Dear,

giakoum

Thanks for your help.

but

some times i need to select day and month .

and defalut selection sholud be 2012.

so some body help me to solve this issue.

Thanks,

Mukram.

Re: Need a help to create a Master calender

Fri, 15 Jun 2012 20:14:51 GMT

Hello Mukram,

Try using the possible() function as below:

sum({$<StartDate = P(CalendarDate)>} Sales)

You can select a year, month or any other field from the Calendar and you should get the related records in your tables.