Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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