topic Count Key values from one table, but not all tables in QlikView

Count Key values from one table, but not all tables

Thu, 11 Sep 2014 12:41:52 GMT

I would like to count the number of distinct key value (AccountID) on one table (TableA), but not count the key values on another table (TableB). I have attached a QVW to illustrate. In TableA, there are 4 distinct AccountIDs, but when using count distinct, it returns 8, which is the distinct count across all tables that have an AccountID column. I would like to retreive the distinct count from only TableA. Any ideas?

Thanks!

Re: Count Key values from one table, but not all tables

nam — Thu, 11 Sep 2014 12:45:33 GMT

put a flag in each table with value of 1 and sum the appropriate in the UI.

so in the set analysis put flag=1 for the appropriate table when counting

Re: Count Key values from one table, but not all tables

Anonymous — Thu, 11 Sep 2014 12:48:04 GMT

both table are concatented into one table Holding all values. so 8 is the correct answer.

if you Need two table you have to define for table b

Table B

noconcatenate load ...

but then you have the same field in two tables and the result will be the same.

to get only the values of table A you need to gibt AccountID a different Name than

in TableB!

TableA:
AccountID1

TableB:
AcountID2,

...

What is the Business issue? The current example makes no sense.

Re: Count Key values from one table, but not all tables

avinashelite — Thu, 11 Sep 2014 12:52:49 GMT

Hi Robert,

Please find the attachment for the solution.

Regards,

@vi

Re: Count Key values from one table, but not all tables

anbu1984 — Thu, 11 Sep 2014 12:53:21 GMT

Try this