2 Replies Latest reply: Nov 23, 2013 8:27 AM by Bill Markham RSS

    How to build a dotpot

    Hans Müller

      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