3 Replies Latest reply: Aug 2, 2013 7:49 AM by andydudley RSS

    Basic Bar Chart Help please

      Hi,

       

      I am a newcomer to Qlikview and have just started to build my first proper report. I'm stumped with a bar chart I'm trying to create.

       

      what I want to show is how many calls we receive per day, so on the x axis, I want the date, and the y axis is the number of calls.

       

      I've got my chart set up as so:

      Dimensions =Date(CreatedDateTime)

      Expression =Count(ContactID)

       

      Yet I still end up with a series of '1's in my chart (as shown in attached screenshot).

       

      CreatedDateTime is a DateTime field in my database, and I only want to track calls by day at the moment, not by the time of the call.

       

      How can I group these by the date?

       

      Many apologies that this is probably such a simple question, feeling like a right dunce and I can't find anything sensible in the Developer or Designer course documentation.

       

      QlikviewChart.png

       

      Thanks for any hints or tips.