topic Re: Expression based Dynamic Symbols in GeoAnalytics

Expression based Dynamic Symbols

naeemhaq — Sun, 11 Mar 2018 21:57:05 GMT

Hello fellow members.

I am working on a map bubble layer and I want to select dynamic images/symbols based on Event IDs. I also want to limit the points i.e. only show points that match the criteria. Below is my expression.

if(event_id = 38, 'https://upload.wikimedia.org/wikipedia/commons/3/3e/Rightblackarrow40.svg'

or event_id = 20020, 'https://upload.wikimedia.org/wikipedia/commons/3/30/Downredarrow40.svg')

Problem is that only condition after ‘or’ is returning the right symbol/image but the first one is returning blue dot (i.e. no image/blank dot). I did a lot of googling but no luck.

Please suggest if there is a clever way of doing this because I have about 10 event IDs with 10 different symbols. I also have to somehow put it in a legend.

I would really appreciate your help.

thanks

Re: Expression based Dynamic Symbols

Patric_Nordstrom — Mon, 12 Mar 2018 11:29:06 GMT

Hi Naeem,

Should work, just make sure that the expression evaluates to a string with the url. Test with a table with the same dim and meas.

An inline table would also work, then just use icon_url as the epxression.

load * inline [

event_id, icon_url

38, 'https://upload.wikimedia.org/wikipedia/commons/3/3e/Rightblackarrow40.svg'

20020, 'https://upload.wikimedia.org/wikipedia/commons/3/30/Downredarrow40.svg'

];

Thanks,

Patric

Re: Expression based Dynamic Symbols

naeemhaq — Mon, 12 Mar 2018 22:44:42 GMT

Hi Patric,

thanks alot for your answer and sorry for my newbie questions. would it be possible for you to elaborate further on "expression evaluates to a string with the url".

Here is what I am trying:

Qlik Sense version Nov 17, below is my Load Script in the Symbol Expression window of a Bubble Layer.

But I am getting below error and could not fix the syntax. Do you know what I am doing wrong.

Re: Expression based Dynamic Symbols

jonathandienst — Tue, 13 Mar 2018 05:35:36 GMT

I suggest that you remove the redundant quotes from the url and put the closing bracket and semi-colon onto a new line.

Re: Expression based Dynamic Symbols

Patric_Nordstrom — Tue, 13 Mar 2018 14:22:44 GMT

Hi Naeem,

If you use "load * inline", that goes into to your load script.

Your expression should probably look like this:

=if(event_id = 38, 'https://upload.wikimedia.org/wikipedia/commons/3/3e/Rightblackarrow40.svg',

if(event_id = 20020, 'https://upload.wikimedia.org/wikipedia/commons/3/30/Downredarrow40.svg'))

Thanks,

Patric