1 Reply Latest reply: Jun 23, 2011 12:36 PM by Arun Raj RSS

    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!

        • 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