Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Problem with Graph Axis

Hi,

I am making a graph with the weekdays (sun,mon, tues..etc) on the x-axis and hours on the y-axis. Problem is that my table doesnt have the hours field in it. I do have a timestamp but that wont cover all 24 hrs.

So i want to know how i can generate numbers/hours 1 - 24 in Qlikview.

Thanks!

1 Solution

Accepted Solutions
Not applicable

Re: Problem with Graph Axis

Hi,

Pls find the attached file and let me know if this is how you want it.

I have created a table called Hour which has all hours from 0 to 23, using autogenerate

Script:

Hour:

LOAD

0+recno() as EventHour

autogenerate 23;

EventHour must be associated to the Hour(timestamp)

Regards

Arun

1 Reply
Not applicable

Re: Problem with Graph Axis

Hi,

Pls find the attached file and let me know if this is how you want it.

I have created a table called Hour which has all hours from 0 to 23, using autogenerate

Script:

Hour:

LOAD

0+recno() as EventHour

autogenerate 23;

EventHour must be associated to the Hour(timestamp)

Regards

Arun