topic Re: Duplicates in the display in QlikView

Duplicates in the display

Thu, 04 Feb 2016 16:49:20 GMT

Dear QV Experts

When i select the Month ' July' from the list box, i was surprised to see one additional rows.

After analysis i found due to the Newserv Id, though the Acknowledgement Sent Date Column in Jan 2016, it displays in July 2015.

The Expression used,

= Count({<DateType = {'Received'}>}Acknowledgement)

Can you please suggest me how to get rid of this duplicate row.

Re: Duplicates in the display

Chanty4u — Thu, 04 Feb 2016 16:51:58 GMT

= Count(DISTINCT{<DateType = {'Received'}>}Acknowledgement)

Re: Duplicates in the display

sunny_talwar — Thu, 04 Feb 2016 16:53:48 GMT

May be this:

=Count({<DateType = {'Received'}, [Newserv Id] = {"=[Acknowledgement Sent Date] = Max(TOTAL <[Newserv Id]>[Acknowledgement Sent Date])"}>}Acknowledgement)

Re: Duplicates in the display

swuehl — Thu, 04 Feb 2016 16:53:56 GMT

How is your month field related to the two dates shown in the chart.

Maybe it's also related to [Date Received], which is July?

Re: Duplicates in the display

sunny_talwar — Thu, 04 Feb 2016 16:55:55 GMT

Yes you are right, I helped OP to implement a Canonical Calendar in one of the previous posts.

UPDATE: Link to previous post -> How to have two date for a list box

Re: Duplicates in the display

Thu, 04 Feb 2016 17:06:44 GMT

Thanks Suresh, Sunny.

But the solution is not working for me.

Re: Duplicates in the display

sathishkumar_go — Thu, 04 Feb 2016 17:10:33 GMT

Hi Sasi,

Could you please explain a bit more?

1) From where you are deriving the month field?

2) What is the relationship or link between month table and DataType, Acknowledgement, NewServ Id, Status, Area, Date Received and Acknowledgement Sent

-Sathish

Re: Duplicates in the display

swuehl — Thu, 04 Feb 2016 17:11:45 GMT

Any other expressions / set analysis used?

Could you share a sample QVW?

Re: Duplicates in the display

Thu, 04 Feb 2016 17:18:13 GMT

Please find enclosed the qvw & input file.

If Dec month selected. then one additional row of January also displayed.

This is because of unique Newserv id.

Please suggest me how to get rid of this.

Re: Duplicates in the display

sathishkumar_go — Thu, 04 Feb 2016 17:53:29 GMT

Hi Sasi,

Two things I have noted.

1) Remove synthetic key

2) some of the id is repeating Example 143678, How the id will repeat?

-Sathish

Re: Duplicates in the display

swuehl — Thu, 04 Feb 2016 18:11:47 GMT

Maybe like attached.

I've removed the syn table by dropping one table and changed the key for the link table.

Re: Duplicates in the display

Thu, 04 Feb 2016 18:38:26 GMT

Excellent. The same was expected. Thanks a lot.