topic Re: Table Key problem in QlikView

Table Key problem

dhborchardt — Tue, 09 Apr 2013 19:49:49 GMT

See attached Table Viewer screen shot (key.jpg). I have three tables with employee information. Each table is joined with the 'Personnel Number' or 'HrmPerNum'. Problem comes in when I want to start clicking by date. If I click on January I will see expected results from the Hrm_VpTot table but it does not work to filter on the Hrm_VpTimeCardAudit table. I understand why this does not work but cant seem to figure out a scenario where I can use one calendar throughout the application. Is this possible? Do I need to use a different calendar for each table I need to filter by date? Some other method?

Re: Table Key problem

Gysbert_Wassenaar — Fri, 12 Apr 2013 11:40:21 GMT

Filtering on one date field will not select the same dates in other date fields. For that you need to use Field triggers. There are several options. See this tutorial for one solution. That only selects dates in one field, but you can just add actions to apply the date selections to another date field too.

It's often a good idea to create different calendars for different date fields. See this discussion for more information.

Re: Table Key problem

dhborchardt — Fri, 12 Apr 2013 15:11:03 GMT

Good stuff. Thank you.