topic Re: show all except one in QlikView

show all except one

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi all

I have a data like below

Country	Capital city
United Arab Emirates	Abu Dhabi
United Kingdom	London
United States of America	Washington, D.C.
Uruguay	Montevideo

india karnataka

india pune

india kolkatha

here my requirement is like I want to display the result india =Karnataka and rest all should display [inida=pune and kolkatha should not display ]

how to achieve this?

Re: show all except one

Anil_Babu_Samineni — Tue, 28 Nov 2017 10:33:45 GMT

May be this?

Load Country, [Capital city] from Table where Country = 'india' and [Capacity city] = 'karnataka';

Re: show all except one

OmarBenSalem — Tue, 28 Nov 2017 10:34:12 GMT

sthing like:

sum({<"Capital City" -= {'pune','kolkatha'}>}YourMeasure)

Re: show all except one

soniasweety — Tue, 28 Nov 2017 10:35:42 GMT

It will give only Karnataka data only na ... I want other data should display

Re: show all except one

OmarBenSalem — Tue, 28 Nov 2017 10:36:59 GMT

if u want to have only karnataka as ur only capital city fo india and not having to deal with the other 2; then do not import them in ur script:

I mean, sthing like:

load

Country,

"Capital city" from source where "Capital city"<>'pune' and "Capital city"<>'kolkatha';

Re: show all except one

Anil_Babu_Samineni — Tue, 28 Nov 2017 10:38:44 GMT

This will deserve

Load Country, [Capital city] from Table where Not WildMatch([Capacity city], 'pune', 'kolkatha');

Re: show all except one

devarasu07 — Tue, 28 Nov 2017 10:41:21 GMT

Hi,

back end method 1,

Fact:

LOAD * INLINE [

Country, Capital city

United Arab Emirates, Abu Dhabi

United Kingdom, London

United States of America, "Washington, D.C."

Uruguay, Montevideo

india,karnataka,

india,pune,

india,kolkatha,

] where not Match([Capital city],'pune','kolkatha');

Method 2;

u can also add front end dimension Country, city as calculated dim

=if(not Match([Capital city],'pune','kolkatha'),[Capital city])

Re: show all except one

Anil_Babu_Samineni — Fri, 01 Dec 2017 05:41:14 GMT

Try to close this thread, If issue got resolved by flag "Correct Answer"

Re: show all except one

shivanisali — Fri, 01 Dec 2017 06:10:09 GMT

Try this:

LOAD * INLINE [

country, city

United Arab Emirates, Abu Dhabi

United Kingdom, London

United States of America, "Washington, D.C."

Uruguay, Montevideo

india , karnataka

india , pune

india, kolkatha

]

where country <>'india' or city<>'pune' and city<>'kolkatha';

Re: show all except one

soniasweety — Fri, 01 Dec 2017 06:45:42 GMT

Thanks all all suggestions good it worked well