Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Leverage your QlikView investment to modernize BI – see how! Join Group
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Table shows wrong values

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 . 

1 Reply
Creator III
Creator III

Re: Table shows wrong values

Any help on the above mentioned issue