topic how to add expression in google map api using scatter chart in QlikView

how to add expression in google map api using scatter chart

Wed, 16 Dec 2015 13:09:49 GMT

Hi,

I'm trying to design a heat map using scatter chart (with google API).

With the help of the document provided from our community, I made a basic google map using scatter chart.

My map is now showing Area wise Number of Patients.

i.e (When i mouse over the point on map it is showing Area name and Count of patients).

For each area I'm having Diseases also.

So, I need to show the Number of patients under each disease and Area wise.

i.e (When i mouse over the point i need to get the area name and disease name-Patient Count).

The step by step design document is attached. Kindly find the attachment and screen shot of my map.

Kindly help me.

Thanks,

Adithyan

Marcio_Campestrini — Fri, 18 Dec 2015 12:39:30 GMT

Adithyan

To see what you want I suggest you two ways:

1) Create various expressions (after the third expression) in your chart, selecting in 'Display Options" the Text as Pop-up option

2) Create one expression (the forth expression of your chart) and to concatenate the diseases using Concat.

Hope this help you.

Mon, 21 Dec 2015 06:50:30 GMT

Hi Marcio,

Thanks for your reply.

I had tried your suggestion. But still I'm not getting.

Can you help me to write the concat expression.

my dimensions are, AreaName,DiseaseName & PatientId.

Thanks,

Adithyan

Marcio_Campestrini — Tue, 17 May 2016 13:13:29 GMT

Hi Adithyan

With Concat: Concat(value, separator), like Concat(AreaName, ',')

With &: AreaName & ' - ' & DiseaseName...

Or create a table to shw the data when selecting a value in your map.

Marcio_Campestrini — Mon, 31 Oct 2016 18:55:13 GMT

Have you solved your problem? If you did, please choose the correct answer and help us to keep community focused.

Marcio_Campestrini — Mon, 29 May 2017 14:12:44 GMT

Got you issue solved? Please mark helpful/correct answers.