topic Scatter Chart Map in QlikView

Scatter Chart Map

microwin88x — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have a Scatter Chart as a Map (see attached QVW).

The thing is I need the following: I don't want to see all city bubbles on the first place. I need to show only the corresponding bubble for the user who logs in, by using function OsUser() where in my company I get UserXXX:

Do you know how to do this? That when I open the app show only the bubble associated to my City?

---

The thing is that I don't want to reduce all the data for a specific City. I need to show all the data for all users.

The only issue I need to solve is with the map. Let's say you're User005. Then when I open the app it should show only the bubble for User005, but still showing the all the data for the rest of the app...

---

Thanks!!!

Re: Scatter Chart Map

maxgro — Wed, 27 Jul 2016 14:36:39 GMT

maybe a dimension like

if(User = 'User018', CityId)

replace 'User018' with OSUser()

Re: Scatter Chart Map

Nicole-Smith — Wed, 27 Jul 2016 14:37:01 GMT

You can add set analysis to each of your expressions on the map to only show the data for the user.

For example,

Longitude:

=SUM({<User={$(=OSUser())}>} round (256*pow(2,($(var_zoom)-1)))+( longitude *((256*pow(2,$(var_zoom)))/360)) )

Latitude:

=SUM({<User={$(=OSUser())}>} ((256*pow(2,($(var_zoom)-1)))+((0.5*log((1+(sin((latitude)*pi()/180)))/(1-(sin((latitude)*pi()/180)))))*((-256*pow(2,$(var_zoom)))/(2*pi())))))