topic X axe with string dimension in QlikView

X axe with string dimension

jvitantonio — Tue, 25 Oct 2011 14:53:40 GMT

Hi all,

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?

Thanks.

X axe with string dimension

RSvebeck — Wed, 26 Oct 2011 06:42:08 GMT

You need to generate a new field "TimeIntervall" in you load script which would then be your new string dimension that you use in the chart.

//Robert Svebeck

X axe with string dimension

jvitantonio — Wed, 26 Oct 2011 07:06:37 GMT

Hi Robert, thanks for your time.

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.

Any other thoughts?

X axe with string dimension

RSvebeck — Wed, 26 Oct 2011 10:12:36 GMT

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?

Re: X axe with string dimension

jvitantonio — Wed, 26 Oct 2011 10:38:19 GMT

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".

Re: X axe with string dimension

RSvebeck — Wed, 26 Oct 2011 10:56:53 GMT

I now see what you mean.

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.

Regards,

Robert Svebeck

Re: X axe with string dimension

jvitantonio — Wed, 26 Oct 2011 12:29:51 GMT

well, it's not really what I need but thanks for your time. This gives me an idea