Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Have you tried a scatter chart with dimension city and the two expressions
=sum(population)
=sum(jobs)