Change y-axis from number to text

[#1]

Hello all!

I am new on Qlikview and try to make a prototype.

My prototype is about a questionary application. All answers can be from 1 till 5; 1 is poor and 5 is excellent.

The first sheet of the customer is an overview of all average scores. The average is perfect, but i would like the text poor, excellent, etc instead of 1 till 5. See example

Can I change this and how?

Best regards,

Patricia

[#2]

Hello,

You could stick in an inline table. Then load the Grade field as the Y axis?

Not sure if this would work worth a try!

LOAD * INLINE [

Score, Grade

5, Excellent

4, Good

3, Average

2, Not Bad

1, Poor

0, Rubbish

];

[#3]

Go back to the script & write below code inside your script.

if(scale=1,'Poor',

if(scale=2,'Average1',

if(scale=3,'Average2',

if(scale=1,'Average3',

if(scale=1,'Excellent'))))) as Text Scale

Take this field TextScale in your chart, it will probably give u answer.

[#4]

Hi,

You can write in your dimension.

=if(Marks='1','Poor',
if(Marks='2','Better',
if(Marks='3','Best')))

Regards,

Ravi

[#5]

Thank you all! Unfortunetely all 3 solutions did not work yet.

The problem is that if i insert a dimension it will automatically shown as x-axis instead of y-axis.

With the load inline in the script I'll get a nice new table, but i do not know how to insert this in the chart as y-axis.

I would like to have this extra table, so thank you for that. I can use this table for alle questions (about 120) I think.

The only question now is how I'll get in as the y-axis.

[johnw]

I'm not thinking of anything clever. You could fake it by making a static axis (min 1, max 5, step 1) and overlaying a text box or boxes on the chart.