Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Qlik Sense: Maps

Hi Qlik Community,

I'm new at Sense and I'm wondering if we can add more than one measure in a Map graphic. Can you help me?

I have some urgency on this isse in order to close a suggestion for a potencial customer.

Thanks in advance!

Vera Gomes

Tags (3)
5 Replies
Employee
Employee

Re: Qlik Sense: Maps

In a bubble/point map , you can have 1 measure determine the size of the bubble and a 2nd measure determine the color intensity of the bubble. 

Would that work ?

To do this use color 'by expression' and use a colormix() function to produce a gradient.

Not applicable

Re: Qlik Sense: Maps

Hi Jonathan,

Not really, we have the requirement to show different metric values in the map graph. This is not possible with Qlik Sense?

Thanks.

Vera Gomes

Employee
Employee

Re: Qlik Sense: Maps

Do you have a sample image / screenshot you could share ? Tools aside, i could think of a few visual ways a map could convey this.. if you had a concept in mind that might help.

Not applicable

Re: Qlik Sense: Maps

Something like this, were different colors correspond to different metrics:

Employee
Employee

Re: Qlik Sense: Maps

Hi yes i think so , and if the different metrics correspond to different points on the map then there are less visual design elements to take into account.

The technique i can propose involves:

1. Loading the source data into 1 table that has , among other fields, 2 fields:

    Metric Name

    Metric Value

    where metric name is the name of the metric (like 'sales') and metric value is the numeric amount ( like 100)

2. Then when you create a map, add a measure of sum( [Metric Value])  but on the Presentation/Color change the color to be by expression and add something like;  if(MetricName='Sales',argb(120,0,255,255) , argb(120,255,0,255))  ...where the 2nd and 3rd parameters are the colors you want.

i uncovered that more things are needed when you have metric values for multiple metrics on the same points.. how best to represent ?

a) you could add a set of geopoints for each metric where the lat/long is slighlty different each time , so that mulitlpe bubbles show up for a point when there is multiple metrics and they  show up side by side .

b) As above, but instead of worrying about altering the points, use the argb() function whose 1st argument determines how transparent the color is... so that the points are visible through each other and overlap (screenshot below)

Both have strengths / weaknesses but both require some data modelling techniques and i think we can probably make this a little easier overall to setup.

Attached is a QVF where you can see how the load has been strucutred . its a little technical but i hope it helps you !

Capture.PNG