4 Replies Latest reply: Feb 20, 2018 5:14 AM by Eric JH Pasteleur RSS

    Scatter plot : fourth dimension

    Eric JH Pasteleur

      Good afternoon,

       

      I'm a new Qliksense user (3 hours of experience), I am not a developer but I am user with strategic tools like Planisware, SAP xRPM, etc...for business purpose

       

      In the context of presenting bubble charts (called Scatter plot in your tool) to support and facilitate the decision making process of the board of directors, I would like to display a scatter plot with 4 dimensions (color being a measure).

       

      I have successfully created the X,Y, Size measures, with the right scaling, legends etc... but I am blocked with the color...

       

      The "availability of expertise" is the measure I want to display as a color for the several applications of my portfolio (We intend to make decisions across a huge portfolio of IT applications).

      Each application (dimension of my chart being the title of the application) has got one measure of availability of expertise (from 1 to 6)

       

      My purpose is to have the applications with an expertise at 0 having a black bubble color;  1 : dark blue, 2 : dark green, 3 : red 4 amber ; 5 yellow 6 : white

       

      That's all !!!

       

      if((Avg[Global Availability of Expertise] = 1),Black(),

          if((Avg[Global Availability of Expertise] = 2),Grey(),

             if((Avg[Global Availability of Expertise]>2),White())))

       

      or also :

       

      if(([Global Availability of Expertise] = 1),Black(),

          if(([Global Availability of Expertise] = 2),Grey(),

              if(([Global Availability of Expertise]>2),White())))

       

      But nothing is working.... all the bubbles are grey :-(

       

      Could somebody provides me with an answer for this simple but key question (as it is required for all the graphs I 'm going to display...)