Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Hide values between two tables

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.

1 Solution

Accepted Solutions
MVP
MVP

Re: Hide values between two tables

add a listbox with expression

or the same expression in a calculated dimension of a chart

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

1.png

7 Replies
cjohnson
Contributor II

Re: Hide values between two tables

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

image24.png

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.

Not applicable

Re: Hide values between two tables

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).


MVP
MVP

Re: Hide values between two tables

add a listbox with expression

or the same expression in a calculated dimension of a chart

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

1.png

cjohnson
Contributor II

Re: Hide values between two tables

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.

Not applicable

Re: Hide values between two tables

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.

Not applicable

Re: Hide values between two tables

It's done!

i didit with axgro‌ method.

Thank to for you both.

cjohnson
Contributor II

Re: Hide values between two tables

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)

image25.png

Updated document attached.

Community Browser