topic Re: Hourly data, showing only date on x-axis in QlikView

Hourly data, showing only date on x-axis

Wed, 21 May 2014 05:21:40 GMT

Hi,

I have hourly data on a line chart, and I'm using calculated dimension to show only date on the x-axis.

=date(MyDateTime, 'dd/MM/yyyy')

This gives me hourly data without having timestamps on x-axis.

Is there any way to show only distinct dates on the x-axis, instead of having the same date repeat as many times as it fits in the chart?

Re: Hourly data, showing only date on x-axis

Anonymous — Wed, 21 May 2014 05:26:53 GMT

Covert this timestamp to date in script itself and create a new field,

Then using new field will resolve your issue.

Re: Hourly data, showing only date on x-axis

ashfaq_haseeb — Wed, 21 May 2014 05:28:21 GMT

write the below code in your backend.

date(floor(MyDateTime)) as NewMyDateTime

Use this field instead.

Regards

ASHFAQ

Re: Hourly data, showing only date on x-axis

Wed, 21 May 2014 05:48:20 GMT

Won't this give me datapoints only for each day instead of each hour? I want smooth line of hourly data, not straight lines just for each day. But I want the x-axis legend to only have dates instead of timestamps (hours).

Re: Hourly data, showing only date on x-axis

Anonymous — Wed, 21 May 2014 05:50:49 GMT

Can you upload some sample data....

Re: Hourly data, showing only date on x-axis

Wed, 21 May 2014 06:19:51 GMT

I hope this image clarifies what I'm trying to do

Re: Hourly data, showing only date on x-axis

ashfaq_haseeb — Wed, 21 May 2014 06:23:12 GMT

Hi,

Try my solution. It must work.

Or just share your sample app.

Regards

ASHFAQ

Re: Re: Hourly data, showing only date on x-axis

Anonymous — Wed, 21 May 2014 06:30:28 GMT

PFA

Hope it helps

Re: Hourly data, showing only date on x-axis

Wed, 21 May 2014 07:13:55 GMT

Yes, this is what I'm looking for

I'm quessing the "overlay" trick is the only way to achieve this?

Re: Hourly data, showing only date on x-axis

Anonymous — Wed, 21 May 2014 08:30:36 GMT

Yes I think so