topic Re: Hide values between two tables in QlikView

Hide values between two tables

Mon, 26 Jan 2026 18:19:17 GMT

Hello!

There two tables with country names: in the first table there are 15 names and in the second one, 160 names.

I want to merge both tables, but i only want to see the names that are repeated, hiding the unique registers from the second table.

Example:

Table 1

Country

Germany

Canada

USA

Table 2

Country

Germany

Canada

USA

Colombia

Argentina

Brazil

Norway

in this example i want to hide Colombia, Argentina, Brazil, Norway.

Re: Hide values between two tables

cjohnson — Thu, 24 Sep 2015 01:24:04 GMT

Maybe you can try to introduce a flag in your script that identifies the duplicate values as shown below:

Your chart can then use set analysis to only show the duplicate values if necessary. Please see attached for more details and let me know if it helps.

Re: Hide values between two tables

Thu, 24 Sep 2015 16:10:47 GMT

Hello, Camile! thank you for your answer,

That is really close to what i'm looking for, but it still show the extra names that i want to hide (the unique ones).

Re: Hide values between two tables

maxgro — Thu, 24 Sep 2015 16:31:17 GMT

add a listbox with expression

or the same expression in a calculated dimension of a chart

=aggr(Only({$ <Country={"=count(Country)>1"}>} Country),Country)

Re: Hide values between two tables

cjohnson — Thu, 24 Sep 2015 17:06:27 GMT

OK. I wasn't sure if you wanted the hidden values in a table/chart or in a list box or both. If it's in the table you should still be able to use the method above. If it's in a list box you can use maxgro‌ method below or you can use the following expression instead:

=AGGR(ONLY({<fExists = {1}>}Country), Country)

See attached for implementation of this.

Re: Hide values between two tables

Thu, 24 Sep 2015 18:25:44 GMT

Still not hiding the extra names (it's a ListBox), but i'm using the visualization option to hide the excluded values. It's a intermediate solution using fExists Box.

Thank you all.

Re: Hide values between two tables

Thu, 24 Sep 2015 19:38:12 GMT

It's done!

i didit with axgro‌ method.

Thank to for you both.

Re: Hide values between two tables

cjohnson — Thu, 24 Sep 2015 19:51:05 GMT

I'm not sure why it wouldn't hide the extra names -- all the extra names are being hidden from my example.

Another option you have is to not use the existence flag and create a pseudo list box using an expression like the one found below:

IF(SUM(fTable1)+SUM(fTable2) >1, 1)

Updated document attached.