topic Re: Combo Chart - Date Dimension in QlikView

Combo Chart - Date Dimension

microwin88x — Tue, 28 Jul 2015 15:04:02 GMT

Hello,

I have a Combo Chart with:

This is the Combo Chart with all the values for each Date with the corresponding format (DD/MM/YYYY HH:MM:SS):

What I need is to apply the setting Continuous under Axis > Dimension Axis keeping the Date format that I'm using (DD/MM/YYYY...)

In the following Chart I've changed the setting to Continuous but the Date format has changed to numeric:

Is there any way to keep the Date format (DD/MM/YYYY HH:MM:SS)?

Thank you!!!

settu_periasamy — Tue, 28 Jul 2015 15:08:29 GMT

did you try this ?

microwin88x — Tue, 28 Jul 2015 15:15:43 GMT

But the thing is that the Date is not an expression, I have it as a Dimension.

I've tried using a Calculated Dimension with DATE(MyDate,'DD/MM/YYYY') but I still get a numeric Date.

settu_periasamy — Tue, 28 Jul 2015 15:18:42 GMT

is it possible to post the sample?

settu_periasamy — Tue, 28 Jul 2015 15:32:34 GMT

Try this,

In this dimension put Date (no calculated dimension)

if your combo chart is continuous option, then you can see the Continuous Axis in the Number Tab.

just try to change like below

microwin88x — Tue, 28 Jul 2015 15:46:22 GMT

Perfect! Solved.

Thank you!