topic Re: Count row in two straight tables in QlikView

Count row in two straight tables

Black_Hole — Sat, 16 Nov 2024 20:50:40 GMT

Hello all,

I would like to count the number of rows in two tables. The problem is that in these two tables, I have the same key fields (A,B,C).

Table 1: 4 fields

A B C D

Table 2: 3 fields

A B C

Consequently, I don't how can I use the function Count() and avoid a wrong result.

My purpose is to create a pie chart representing the number of rows in each table.

Please could you help me.

Thank you in advance for your help.

Re: Count row in two straight tables

dplr-rn — Fri, 17 May 2019 16:12:20 GMT

not 100 % clear why you need 2 tables and what are you counting.
but going with your approach. create a Type field in each table. e.g. Table1 - Type='Table1', Table1 - Type='Table2'
use this type value in set analysis when doing your count
e.g. count({<Type='Table1'>}A)

Re: Count row in two straight tables

Black_Hole — Mon, 20 May 2019 07:16:50 GMT

Hello @dplr-rn,

Thank you very much for your solution.

I would like to try it.

Please could you explain how you can create a type field.

Thank you in advance for your help.