Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

how to display all countries names in the list box without one specific city?

could u please help with this question?

1 Solution

Accepted Solutions
Highlighted
Specialist III
Specialist III

Re: how to display all countries names in the list box without one specific city?

We can deselect not required values like using =if(Business<>'mumbai',Business) so except mumbai all the values will be displayed

View solution in original post

6 Replies
Highlighted
Specialist III
Specialist III

Re: how to display all countries names in the list box without one specific city?

in list box->properties->General->Field->Expression(Instead of direct field)

=if(Business='Mumbai',Business) then it will display only mumbai others will not be displayed

Highlighted
Specialist III
Specialist III

Re: how to display all countries names in the list box without one specific city?

We can deselect not required values like using =if(Business<>'mumbai',Business) so except mumbai all the values will be displayed

View solution in original post

Highlighted
Master III
Master III

Re: how to display all countries names in the list box without one specific city?

Sri,

Can be done in two ways:(Suppose want to show all countries except Poland)

Script Side :

....

FROM

[.....

Where Country <>'Poland';

Front Side as Calculated exppression:

=if(Country<>'Poland',Country)

Thanks,
AS

Highlighted

Re: how to display all countries names in the list box without one specific city?

‌please provide sample data and expected result.

regards

Marco

Highlighted
Not applicable

Re: how to display all countries names in the list box without one specific city?

awesome sasi...i got it. thank u for ur answer

Highlighted
Specialist III
Specialist III

Re: how to display all countries names in the list box without one specific city?

Can please mark it as correct answer, so that it might helpful to some one.