topic Understanding concatenate in QlikView

Understanding concatenate

Michiel_QV_Fan — Mon, 10 Apr 2017 06:48:59 GMT

Hi, if I concatenate 3 tables with the same KEY fields but deviating facts I have the following results:

Loading 10 lines:

After first table resutl is 10 lines

After second table result is 30 lines

After third table result is 70 lines

If I add an additional unique key per table this happens:

After first table resutl is 10 lines

After second table result is 20 lines

After third table result is 30 lines

I'm wondering if I get a doubling of my lines in the first method (and since I load millions of rows that is not preferable.

QlikView shows unique values only in table box but the table viewer does count 70 rows.

What is really happening under the hood, are there 70 lines that consumes resources? Thanks

Re: Understanding concatenate

Muthu — Mon, 10 Apr 2017 07:01:13 GMT

Hi,

Please go thought the below link. Understanding Join, Keep and Concatenate

Regards,

Muthu

Re: Understanding concatenate

ahaahaaha — Mon, 10 Apr 2017 07:01:42 GMT

Hi Michiel,

Can we have a fragment of data and your download code?

Regards,

Andrey

Re: Understanding concatenate

gardenierbi — Mon, 10 Apr 2017 07:33:34 GMT

Hi Michiel,

You can't use the TableBox object to count your data in your data model. The TableBox object will show you only the distinct available values in your data model. Use the Table Viewer or a Chart object to count the actual data rows in your data model.