Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

2 Replies
swuehl
MVP
MVP

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

=sum(population)

=sum(jobs)

Anonymous
Not applicable
Author

Thomas

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

Best Regards,     Bill