I need to make a simple line char where my X axe is the time shown as string
"10pm-10:30pm" etc. The thing is I also need to draw a vertical line , and this can only be done if the values are "Continues" If I check this under the char propierties, my time dimension is conversted to a continues value (0.1, 0.2, 0.3, etc) which Idon't need. Is there any way to solve this?
This is not my problem though. I've already generated my dimension. What I can't do is to use my string dimension as a continues dimension that allows me to create a vertical like inthe graph.
Hmm, I don't understand what you mean with the vertical and with the continous dimension.. Can you explain in another way or present that data somehow, perhaps upload a qvw with example data?
Sure, here's the graphic. In order to make the vertical line, you need to go to chart properties, tab Axes, and check "Continuos", then go to Presentation tab-> Add Reference Line ->Location Continuos X.
This works fine when we have a numerica dimension in the X axes as this example, but in my case, I want to show not the number of hours by the hour in a format like "10pm". This is a string dimension and qlik doesn't let me create a vertical line as the dimension is not "continuos".
As you mentioned, the countious X function requires a numeric value. I do not see a solution for this by using reference lines.
A workaround would be to add a second expression with a "if statement". It won't be as nice as a standard reference line, but the effect is similar. See attached.
