Discussion Board for collaboration on QlikView Layout & Visualizations.
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!
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.
i did it almost like you.
Thank you very much