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 in the below table (OPEN as OF) doesn't match the count as shown in the screenshot below it is giving only 1 key dteails, rather then giving 3 keys detail information.
Please find the attachment of the qlikview files .
It will be really great if you can help me on this