QlikView not filtering data properly

[#1]

Hello,

I have the following tables

The table Metrics is a result of concatenating two separate tables that count the number of tickets opened and closed.

OpenTickets: 
Load 
count(monthopened) as numopen,
monthopened as [Year-Month]
Resident Table1
GROUP BY monthopened;


ClosedTickets: 
Load 
count(monthresolved) as numclosed,
monthresolved as [Year-Month]
Resident Table1
GROUP BY monthresolved;


Metrics:
NoConcatenate
load *
resident ClosedTickets;
CONCATENATE
load *
resident OpenTickets;



DROP TABLE ClosedTickets;
DROP TABLE OpenTickets;

The fields monthresolved and monthopened are available in Table1 and they match the format of the Year-Month field in the MasterCalendar. The MasterCalendar is generated using qvc.calendarfromfield.

I put the content of table Metrics in a straight table, where dimension is Year-Month and expressions are SUM of numclosed and numopened. My problem is that whenever I filter the data using any field in Table1, the straight table blanks out, which seems to me a problem in the relation between the two tables.

Anything you suggest to solve this issue?

Thank you very much

[#2]

Hello Marcus,

The only reason why I was formatting the date as such is to use it as a key between my data and the MasterCalendar.

By the way, I provided more info in the previous post.