Text instead of numeric values in Y axis on a Scat... - Qlik Community

Anonymous · ‎2017-07-25

Hi.

According to http://www.learnallbi.com/scatter-chart-in-qlikview/‌ , a Scatter chart is "Scatter chart is very useful in displaying the relationship between 2 numeric values over a dimension."

Now i'm wondering, if I have a column with text values that are either "High" or "Low". Can they be in a y-axis of a scatter chart? See attached file.

I've tried for a while, but it doesnt seems to be working, or maybe Im just doing it wrong..

Thanks in advance

sunny_talwar · ‎2017-07-25

May be use this with the dual function.... Have not tried it, but you can give it a short

Anonymous · ‎2017-07-25

I gave it a shot, but I dont think it's working, or maybe i'm just doing it wrong?

In my load script:

LOAD

Dual(if(Probability= 1, 'LOW', if(Probability= 2, 'HIGH', 'No category')),Probability) as ProbabilityTest

FROM

(ooxml, embedded labels, table is TB01_20170712_154626);

and in the Y-axis expression of my scatter chart, i tried the following:

Sum(Text([ProbabilityTest])

and

Text([ProbabilityTest])

this dosent work, no nodes/plots in my chart are displayed at all...

But when using:

num(ProbabilityTest)

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

neha_shirsath · ‎2017-07-25

Hi,

Go through below link-

Scatter Chart ‒ QlikView

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.

Kushal_Chawda · ‎2017-07-25

I don't think it will be suitable for scatter plot, if you want to use the text then go for bubble char.

Anonymous · ‎2017-07-25

But isn't a bubble chart in qlikview a scatter chart? Or is bubble chart something else?

Anonymous · ‎2017-07-25

yea, it looks like that... What could I use instead? If I want a graph looking like the graph in the attached file in the question above?

Kushal_Chawda · ‎2017-07-26

Only difference between them is, scatter plot uses measures on both X & Y axis, while bubble chart uses dimensions on both X & Y axis.

Anonymous · ‎2017-07-26

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:

scatterchartisthispossible.png

Thanks for taking the time, much appreciated.

Text instead of numeric values in Y axis on a Scatter chart