Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

google maps extension with sort rangesum

Hi Guys,

I need to do custom marker on google maps.

How can I sort and rangesum on google maps extension based on expression (sort , rangesum, cumulation) to display custom marker for each lat/long.

for example.

When rangesum is applied, i will display green marker for rows (lat/long) with rangesum value less than 15

i will display red marker for rows (lat/long) with rangesum value more than 15 and less than 30.

Thank you in advance

1 Reply
Alexander_Thor
Employee
Employee

=if( rangesum() < 15, 'http://greenmarker.png',

       if(rangesum() > 15 AND rangesum() < 30, 'http://redmarker.png', null()

       )

)

Why you want to use rangesum is beyond me though