Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Scatter Chart (Text to Number)

Hi all,

I have the following issue and would be very thankful if someone could help me with this:

I have two set of data

Category A:

1

2

3

4

Category B:

low

mid

high

I want to show this data in a scatter chart, where the X-Axis shows Category A from 1 to 4 and Y-Axis shows Category B from low to high..

So if for one data set Category A is 2 and Category B is "mid", I'd like to get a dot in the matrix (x=2,y=2)..

I guess the problem is that Category B is text and not numbers.. so which expression do I have to use?

For Category A i used : only([Category A]), this however does not work for Category B...

Thank you for any help!

1 Solution

Accepted Solutions
Not applicable
Author

I solved it with the help of a LOAD*Inline:

Load*Inline [

Category B, Category_B_number

low,1

mid,2

high,3

];

And then I used Category_B_number in the expression of the chart.

View solution in original post

2 Replies
Not applicable
Author

I solved it with the help of a LOAD*Inline:

Load*Inline [

Category B, Category_B_number

low,1

mid,2

high,3

];

And then I used Category_B_number in the expression of the chart.

kji
Employee
Employee

Sounds like what you really want is a grid chart (x-y plot with discrete axis values) and not scatter chart (x-y plot with continous numeric values)