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...)
We use Qlik Sense 3.2 and it definitely works and pretty sure it was in 3.0 as we've been doing a over/under coloring on scatter plots since we launched a couple years ago.
We use hex colors not the functions, so that may be the difference and a simple if, but no reason a pick wouldn't work. I tend to test the pick using a text control, just to make sure if resolves to the correct value.