Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rivenbryan
New Contributor

Mapping and Logic

Can anyobdy help me? As you can see, there are too many lines on my map and each line refers to a layer pointing to another country (showing connection)

How can i do a filter? I was thinking about filtering it based on number of packet. So for example, lets say i set a packet of 10, the graph then shows only the connections that contains packet of 10

Capture.PNG

4 Replies
DavidŠtorek
Contributor III

Re: Mapping and Logic

Hi,

try to use a measure with set analysis. Something like Count({$<[pkts]={10}>}[Number of Connections]). Or you can go even further by replacing number in expression with variable (e.g. vPackets) and add an extension qs_variable to set what number of packets are you interested in.

 

Hope that is solution you are looking for 😉

rivenbryan
New Contributor

Re: Mapping and Logic

Do you mind to explain what does that expression does? Sorry,  i am very new.

DavidŠtorek
Contributor III

Re: Mapping and Logic

Hi,
basicaly it does filtering. It counts only such values where field pkts is equal to 10. It gives the same result as if you use filter pane.
Highlighted
DavidŠtorek
Contributor III

Re: Mapping and Logic

Actually do you want to have "default" filter or just to filter as you explore your data? Maybe I misunderstand your needs.