3 Replies Latest reply: Nov 6, 2017 9:30 AM by Biju Krishnan RSS

    Plotting bar graph with distinct time values

    Biju Krishnan

      Hi,

       

      I'm new to Qlik Sense and trying to create a simple visualization but struggling with what I wish to achieve.

       

      I have table which looks like this

       

      BTimeHHMMDestination
      09:43Home
      04:36Walking
      05:29Office
      08:52Walking
      09:07Pub
      09:57Walking
      13:44Office

       

      I was hoping to plot a bar graph with the count of how many times I have visited office during certain class of hours. So between

      05:00 - 06:00 - 1

      13:00 . 14:00 - 1

      And so on.

       

      bar graph.png

      Problem is that time keeps repeating itself.

       

      OR something like the google popular time would also do

       

      google popular times.png

       

      I would prefer to have the calculation in the dimension or measure rather than in the load script but this is just because editing the load script will break the data manager.

       

      Thanks in advance.

       

      Regards,

      Biju