Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Need a help to create a Master calender

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.

4 Replies
Not applicable

Re: Need a help to create a Master calender

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,

export.png

Thanks,

Mukram.

giakoum
Honored Contributor II

Re: Need a help to create a Master calender

Hi

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])


Not applicable

Re: Need a help to create a Master calender

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.


Not applicable

Re: Need a help to create a Master calender

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.

Community Browser