topic Calender based on multiple date fields. in QlikView

Calender based on multiple date fields.

Anonymous — Wed, 08 Aug 2012 08:49:16 GMT

Hi,

I have various date fields in different different tables. And I want to make a calender where all the date should be considilated and will have impact on all the fields. How can I achieve this? Any idea?

Best Regards,

Skumar

Re: Calender based on multiple date fields.

Anonymous — Wed, 08 Aug 2012 08:54:57 GMT

Hi Shubham,

What you could do is create a master calender which is connected to a link tabel.

In the link table you can connect the different date fields from the different tables.

I hope this is helpfull.

Dennis.

Re: Calender based on multiple date fields.

Anonymous — Wed, 08 Aug 2012 09:04:19 GMT

Hi Dennis,

Thanks for your reply. can you attach any sample file for the same. that would be great help.

Best Regards,

Skumar

Re: Calender based on multiple date fields.

Wed, 08 Aug 2012 09:05:56 GMT

Hi Skumar,

Maybe you look after this one: http://community.qlik.com/message/118493#118493

In the last post of John, you have an example file.

Regards Vicky

Re: Calender based on multiple date fields.

Anonymous — Wed, 08 Aug 2012 09:16:58 GMT

A very simple dashboard I made as an axemple. Not sure if it will work for you but take a look at it and let me know ok?

Good Luck,

Dennis.

Re: Calender based on multiple date fields.

Anonymous — Wed, 08 Aug 2012 13:09:52 GMT

Hi Dennis,

Let me work on the given qvw and find out how does it sync with my scanario. Thanks for your help. If works fine I will let you know.

Best Regards,

Skumar

Re: Calender based on multiple date fields.

Gabriel — Wed, 08 Aug 2012 13:15:28 GMT

Hi,

What about renaming the Date fields in each table to same name and then Reload the data.

Let me know if this is helpful.

Best Regards,

Gabriel

Re: Calender based on multiple date fields.

Anonymous — Thu, 09 Aug 2012 04:54:06 GMT

sound interesting!! Let me experiment