Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
soniasweety
Valued Contributor III

show all except one

Hi all

I have a data like below

CountryCapital city
United Arab EmiratesAbu Dhabi
United KingdomLondon
United States of AmericaWashington, D.C.
UruguayMontevideo

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?

1 Solution

Accepted Solutions

Re: show all except one

This will deserve

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
9 Replies

Re: show all except one

May be this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Partner
Partner

Re: show all except one

sthing like:

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

soniasweety
Valued Contributor III

Re: show all except one

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

Partner
Partner

Re: show all except one

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

This will deserve

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
devarasu07
Honored Contributor II

Re: show all except one

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

Capture.JPG

Re: show all except one

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Partner
Partner

Re: show all except one

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';

soniasweety
Valued Contributor III

Re: show all except one

Thanks all all suggestions good it worked well