Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Master Calendar help

I'm having trouble with a qvw I made recently. Its a list of trainings and who has completed what. I was assigned to put a master calendar in it. I did it but as you will see in the qvw attached, the charts and tables on the "Qlikviews stats" tab don't work when the any of the dates are chosen but the rest of the tabs work correctly with my calendar.

The "qlikview stats" tab works correctly with the other list boxes, just not the calendar. Is there something I missed in linking the tables together? Any help would be great.

3 Replies
Not applicable

Re: Master Calendar help

your dates also have timestamps.  so if the timestamp value doesn't match exactly, the rows will not be associated.  try using the floor( ) function to truncate the timestamps portion of the date.

Not applicable

Re: Master Calendar help

Forgive me, but I'm really new to Qlikview. So you'll have to explain a little more.

jsn
Honored Contributor

Re: Master Calendar help

Hey Ethan,

This blog post would be a good place to start in order to understand the dates:

http://community.qlik.com/blogs/qlikviewdesignblog/2012/06/08/get-the-dates-right

Community Browser