I gave it a shot, but I dont think it's working, or maybe i'm just doing it wrong?
In my load script:
Dual(if(Probability= 1, 'LOW', if(Probability= 2, 'HIGH', 'No category')),Probability) as ProbabilityTest
(ooxml, embedded labels, table is TB01_20170712_154626);
and in the Y-axis expression of my scatter chart, i tried the following:
this dosent work, no nodes/plots in my chart are displayed at all...
But when using:
All the nodes in the charts are then being displayed. But on the Y Axis there are only numbers (1 and 2 that is).
But i really wish I could display LOW or HIGH instead of the unclear numers...
Got any more advice? Anything is appreciated
Using the dimensions as X and Y axis is not possible with scatter chart/plot, it will be required to use expressions.
So you mean I should use something else? How can I create a bubble chart using dimensions in qlikview? Using a grid chart? The problem with grid chart, as I see it, is that my X axis will not look like my graph in the attached file. Since it's a grid chart, all X values of all the nodes will appear in the X axis (And I want the X axis to be 500, 1000, 1500 and so on...). I can always group them I guess but then they will all stack and making it unreadable.. And with grid chart i cant really specify the X axis scale either.
So my question to you is, how can i create a bubble chart, using dimensions, that looks something like this:
Thanks for taking the time, much appreciated.
Go through below link-
This says that -
The scatter chart presents pairs of values from two expressions. This is useful when you want to show data where each instance has two numbers, for example, country (population and population growth).
I'm not sure but might be text value we can't show in scatter chart.