Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rajeshthakur292
Contributor II

Issue with creating a map visualization.

I want to create a map visualization which uses the dimension as Region and measure as Sales. Now, i want the map to show only the sites which has negative ebitda. How do i do that?

Thank you!

10 Replies
lironbaram
Honored Contributor II

Re: Issue with creating a map visualization.

hi

try something like

Dimension : Region

Expression : if(Ebidata<0 , Sale) , this should only show you the relevant regions

arulsettu
Honored Contributor III

Re: Issue with creating a map visualization.

can you share sample app

agigliotti
Honored Contributor II

Re: Issue with creating a map visualization.

maybe this:

Dim = Region

Measure = Sum( if( ebitda < 0, Sales, 0 ) )


and finally disable show 0 values option.

rajeshthakur292
Contributor II

Re: Issue with creating a map visualization.

map.PNGHi Liron, i used your expression.This is what it shows now.I only want the bubbles not the crosses. Can you help me with that?

Thank you!

shraddha_g
Honored Contributor III

Re: Issue with creating a map visualization.

Are you using any extension?

rajeshthakur292
Contributor II

Re: Issue with creating a map visualization.

Yes, i am using variable extension and that is used to change the value of sales and ebitda.

shraddha_g
Honored Contributor III

Re: Issue with creating a map visualization.

No I am asking about Map

rajeshthakur292
Contributor II

Re: Issue with creating a map visualization.

No, for map i am using the default map.

rajeshthakur292
Contributor II

Re: Issue with creating a map visualization.

Done!

I used the following expression as measure:

if(ebitda<0,Sum(Sales),0)

and then i unchecked Include zero values.