Line chart, String values at y-axis

Tue, 06 Nov 2012 13:17:35 GMT

Hello everybody,

like i said in the titel of this poste, i tried to display string values at the y-axis of a line chart and it didn´t work.

If i transfer the string values into int´s with the following statement

if(Status = 'Zurückgestellt', 1,if(Status ='Offen',2,if(Status ='In Analyse',3,if(Status = 'Analysiert',4,if(Status ='In Bearbeitung',5,if(Status = 'Realisiert',6,if(Status = 'Abgenommen',8,if(Status='Geschlossen',9,if(Status = 'In Abnahme',7))))))))) as NumStatus,

it works. (On the y-axis is the status of the Project and at the x-axis the date, so you´re able to see when the status did change)

I think the usability with the numbers at the y-axis is not very good and i don´t want wo write a legend wich explains the meaning of every number because i don´t like the look.

Has anybody an idea, how (or even if its just possible......) i can display string at the y-axis of a line chart (Combo-Chart would be ok too).

Thank you very much!

Re: Line chart, String values at y-axis

Tue, 06 Nov 2012 15:35:10 GMT

See if this is kind of what you had in mind. There is not a very easy way to get the string as the axis, but you can kind of fake it by using the Dual function and some text boxes.

Re: Line chart, String values at y-axis

Tue, 06 Nov 2012 16:00:50 GMT

Hey rebeccad,

i did it almost like you.

Thank you very much

topic Line chart, String values at y-axis in QlikView

Line chart, String values at y-axis

Re: Line chart, String values at y-axis

Re: Line chart, String values at y-axis