How to get values correct which are in access database

[#1]

Hi,

Please find attached.

I need to get the number of cases closed by Person(Who) and by WorkItemtype. It is getting values less when compared to values which are in access database. Please could anyone tell me where I am doing mistake.

Thanks.

[#2]

Please any help

[jpapador]

whenever I try to open the attachment Qlikview says "Failed to Load" and then closes.

[#4]

Please colud you find now and help me as I am really struggling with this

[Anonymous]

Hi,

I cann't open the attached document.

Someone else ??

Paul

[jpapador]

are you over reporting or under reporting, any chance you could post a sample of the access data?

[#7]

Hi,

I tried myself opening the documents it's opening for me please try once please

[gopalopsharma]

Hello Amelia,

Are you trying some join/Keep in the script?

or There can be some blank persons/ workitem type, which might create trouble.

[#9]

Yes there is a join in the tables.

please help me how can i set this as this is really frustrating me please

[gopalopsharma]

Hello Amelia,

though I could not see the data model,

but I assume you wish to join "TblClient" with "TblWorkItemtype" and "TblHistory" on workItemtype and ClientID key.

Now I think here is issue. there is one HistoryID in TblHistory which is not present in the TblClient and that is why the data in TblClient is not unique at this level.

Can you please explain what is HistoryID?
If it is the ID for each of the log in of a person,

then it should be in TblClient table.