Values Don't Match

[smilingjohn]

Hi Expertise . 

I need a help on the below mentioned explanation its emergency and i am struggling. Please find my qlikview file attached 

I have two tables
1. Detailed table

2.OPEN as OF

Currently the detailed table is showing the defects by severity
my requirement is to show the equal number of Key for open as of in the below table(OPEN as OF) .

If you look at the Detailed table for Severity 1 and Report Month Dec-2016
the created is 0 and closed is 0 but Open as of has 4 counts.
and when i click on 4 i get four key in the below table(OPEN as OF)

Load date is 1-20-2018.

as shown in the screenshot

This is correct as per the requirement the table (OPEN as OF) show correct number of keys which matches to the count of Open as Of in the Detailed table ( which is 4) .

now i clear the content 

I see that for Report Month jan-2017 Created is 1, closed is 1 and Open as Of is 3 .
when i click on 3 keys in the below table (OPEN as OF) doesnot match the count as shown in the screenshot below
it is giving only 1 , rather then giving 3 keys.

Please find the attachment of the qlikview files . 

(I always observer that the for the Report Month Dec -2016 Counts within table Detailed  the number of Open as of shows correct number of keys in the Second table "OPEN as OF" but don't show proper results for other open as of counts)

I need help on this

Thanks in advance . 

[smilingjohn]

Any solution on this ?

Thanks 

[smilingjohn]

Can any one please look into this