Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
microwin88x
Creator III
Creator III

Scatter Chart Map

Hello,

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


Sin título.png


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:

Sin título 2.png

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!!!

2 Replies
maxgro
MVP
MVP

maybe a dimension like

if(User = 'User018', CityId)

replace 'User018' with OSUser()

Nicole-Smith

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())))))