Count Distinct

[#1]

Hi Guys

I am wring a report that compares a result from a Warehouse and one from an Excel sheet.

Say my Warehouse is like this :

WHCustomer              Amount

ABC                            50

123                             100

Do ray me                    20

ABC                            75

And my excel is like this :

Customer                   Amount

ABC                           50

Fred                           100

Nuals                          50

ABC                           100

On my straight table when I write my match formula I would like a result of 1 for the first ABC.

However I am getting a result of 2 using the following formula - what it is doing is using 2 calculated fields

WHAccount is a text join of Customer and Amount from Warehouse ( I did this is script WHCustomer&Amount as WHAccount) and AccountNumber is a text join Customer and Amount from excel, the RecWh is recno() as RecWH used as an effort to give uniqueness to each row !!)

However it is still just counting all Customer names where ANY account matches

count(if(WHAccount=AccountNumber,RecWH))

I have tried variations of "Distinct" but cant get it , can anyone please advise ?

Thanks

A

[jagannalla]

Can you please attach simple file..

[#3]

HI Jagan

On trying to make a sample Qlikview doc without customer names I seemed to have figured out the issue,

I was looking at the warehouse data and counting which ones of those matched, rather than counting the ones they matched against - thus eliminating duplicates

Thanks a mill for your time tho

A