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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-11-23 07:41 AM

How to build a dotpot

Hello,

i'm new int the world of Qlik View and i have a question regarding to build a correct dotplot.

Now, this is my Excel sheet:

city               population          jobs              

New York     8.300.000          4.500.000

London        7.800.000          3.600.000

Berlin          3.400.000          2.100.000

The dimensions are "population" and "jobs" and now i want to see where the city´s are in the dotplot based on the two dimensions. So my problem is maybe to create a correct formula for the attribute "city"?! Can you help me how it works to create the formula in the Expression formula field?

Thanks,

Thomas

355 Views
0 Likes
2 Replies
swuehl
MVP
MVP
‎2013-11-23 08:12 AM

Have you tried a scatter chart with dimension city and the two expressions

=sum(population)

=sum(jobs)

281 Views
Anonymous
Not applicable
‎2013-11-23 08:26 AM
Author

In response to swuehl

Thomas

I agree with swuehl, attached is a simple example qvw.

Best Regards,     Bill

bb10.qvw
281 Views