Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master
Master

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
Highlighted

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)

View solution in original post

9 Replies
Highlighted

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)
Highlighted
Partner
Partner

sthing like:

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

Highlighted
Master
Master

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

Highlighted
Partner
Partner

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

Highlighted

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)

View solution in original post

Highlighted
Master II
Master II

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

Highlighted

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)
Highlighted
Partner
Partner

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

Highlighted
Master
Master

Thanks all all suggestions good it worked well