Table shows wrong values

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi Expertise Need help .

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

Thanks in advance .

Re: Table shows wrong values

smilingjohn — Wed, 07 Aug 2019 16:31:41 GMT

Any help on the above mentioned issue

topic Re: Table shows wrong values in QlikView

Table shows wrong values

Re: Table shows wrong values