Problem with Graph Axis

[#1]

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!

[#2 · Accepted solution]

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