Only Showing Distinct Records - I don't want that!!

[dinicholls]

Hi,

I have an app pulling through various dispute data from a CSV file.

The problem being is that its not summing all the data, just adding the two distinct rows, using the 'Dispute ID' as the distinct value.

I haven't asked it to do this, and actually need it to add all the rows together including duplicate 'Dispute ID's'

I know all the data has been loaded, how can I get QlikView to sum everything, including the duplicated rows?

Thanks

Di

[#2]

Hi Diane,

I have a slight idea what you mean. But could you upload the qvw to be sure what the problem is?

[dinicholls]

Hi Jelco,

I'll give it a go for you!

The dispute volume should be 18, its showing 6, and the dispute value should be £1652.80, not £192!

Its confusing!

Thanks

Di

[Anonymous]

Your table [Disputes 220914] in your qvw has 230 rows.

When no selections made your Straight table show a Total of [Dispute Volume] to be 230 as well.

This implies to me that all rows are being processed in the object ok.

What leads you to believe rows are being missed by the object ?

[anbu1984]

For this combination do you expect value to be 18? How?

=Count({<Group={'Branch'},AC3={'V01'},[AC3 Name]={'Haydock'}>}[Dispute Count])

[dinicholls]

In the CSV file there are various parameters.

Company 29 is selected, and Branch V01 is selected.

For these selections there are 18 records.

Attached is the CSV of all the records that need to be shown within the disputes, duplicated or not, hence the 18 records.

Thanks

Di

[Anonymous · Accepted solution]

Your load script eliminates all the Q19's and there are 12 of them.

18 - 12 = 6     and that is what you have left

WHERE([Company Number] = '29' And

  code <> 'Q08' And

  code <> 'Q10' And

  code <> 'Q16' And

  code <> 'Q17' And

  code <> 'Q18' And

  code <> 'Q19' And

  code <> 'Q21' And

  code <> 'Q23' And

  code <> 'Q24' And

  code <> 'Q25' And

  code <> 'Q26' And

  code <> 'Q27' And

  code <> 'Q28' And

  code <> 'Q29' And

  code <> 'S01' And

  code <> 'S02' And

  code <> 'S03' And

  code <> 'S04');

[dinicholls]

I'm going to kill them!!

Thank you!

Q19 shouldn't have been included in the CSV file.

I though I was going doo-lally tap!!

Thank you, I shall reverse slowly back to my desk and hide!

Sorry for all the trouble!

[#9]

Great, you've got it allready!