topic Re: List Box conditional Show in QlikView

List Box conditional Show

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I need to create a List Box with few cities and I need to filter the cities that are not in Europe.

I have Longitude and Latitude for every city.

I have tried to use "If" like this:

=If(P_Longitude<=60 and P_Longitude>=11 and P_Latitude<=71 and P_Latitude>=36,1,0)

Obviously it did not work. can someone please help?

Re: List Box conditional Show

sunny_talwar — Wed, 05 Oct 2016 16:19:51 GMT

Is this something you are thinking of doing on the front end of the script or back end?

Re: List Box conditional Show

sunny_talwar — Wed, 05 Oct 2016 16:20:58 GMT

May be like this on the front end:

Aggr(Only({1<Country ={'*'}-{'Europe'}>} City), City)

Re: List Box conditional Show

Wed, 05 Oct 2016 18:46:13 GMT

First, thank you for you answer.

I did not understand it quite well, I am very new with this.

Let me write it again:

I have this table in Excel-

P_Latitude	P_Longitude	Plant_ID	PlantName
-6.181015	106.828335	4	Jakarta
35.680071	139.768522	2	Tokyo
40.713054	-74.007228	3	New York
51.507276	-0.12766	6	London
52.374733	4.898117	1	Amsterdam
55.751615	37.618701	5	Moscow

And I need to create a chart only the cities in Europe.

Re: List Box conditional Show

sunny_talwar — Wed, 05 Oct 2016 18:52:24 GMT

You only have Longitude and Latitude? Don't have a field which explicitly states the name of the Country? Are you trying the if statement in the script to create flags?

Re: List Box conditional Show

settu_periasamy — Wed, 05 Oct 2016 19:00:20 GMT

you can try this expression in listbox.

=If(P_Longitude<=60 and P_Longitude>=11 and P_Latitude<=71 and P_Latitude>=36,'Europe','Others')

But instead of doing like this, you can do it in the script itself. Like

LOAD *,If(P_Longitude<=60 and P_Longitude>=11 and P_Latitude<=71 and P_Latitude>=36,'Europe','Others') as Region;
LOAD * INLINE [
P_Latitude, P_Longitude, Plant_ID, PlantName
-6.181015, 106.828335, 4, Jakarta
35.680071, 139.768522, 2, Tokyo
40.713054, -74.007228, 3, New York
51.507276, -0.12766, 6, London
52.374733, 4.898117, 1, Amsterdam
55.751615, 37.618701, 5, Moscow
];

Then simply create the 'Region' Listbox.

Re: List Box conditional Show

Wed, 05 Oct 2016 19:18:55 GMT

I do not know what flag is.

but I am trying to show in a List Box only the rows that mach the If condition.

Re: List Box conditional Show

sunny_talwar — Wed, 05 Oct 2016 19:57:26 GMT

Does this look like what you want?

I created a flag in the script:

Table:

LOAD *,

If(P_Longitude<=60 and P_Longitude>=11 and P_Latitude<=71 and P_Latitude>=36,1,0) as Flag;

LOAD * INLINE [

P_Latitude, P_Longitude, Plant_ID, PlantName

-6.181015, 106.828335, 4, Jakarta

35.680071, 139.768522, 2, Tokyo

40.713054, -74.007228, 3, New York

51.507276, -0.12766, 6, London

52.374733, 4.898117, 1, Amsterdam

55.751615, 37.618701, 5, Moscow

];

And then used the following expressions for the two list boxes:

1) =Aggr(Only({1<Flag = {1}>} PlantName), PlantName)

2) =Aggr(Only({1<Flag = {0}>} PlantName), PlantName)

Re: List Box conditional Show

Wed, 05 Oct 2016 20:44:49 GMT

Thank you all for you help!!!!!!!!!