0 Replies Latest reply: Feb 17, 2010 9:06 PM by thereverend RSS

    2 Gauges with different selection criteria

    thereverend

      HI!, this is my first question, Im new to QlikView.

      What I want to do is simple:

      2 Guages.

      The first one displays the completion% according to a sales goal of the current day. (Using DocDate as Dimension and SUM(Quantity) as Expression)

      The second one displays the completion % according to a sales goal for the current month. (Using MonthID as Dimension and SUM(Quantity) as Expression)

       

      My code for data load:

       


      SQL
      SELECT
      DocDate
      ,CardCode
      ,CardName
      ,ItemCode
      ,ItemName
      ,Quantity
      ,CONVERT(varchar(20),MONTH(DocDate)) + CONVERT(varchar(20),YEAR(DocDate)) as MonthID
      FROM ODLN


      If I select the correct MonthID I get the 2nd gauge correct. But when I select the current date, the 2nd Gauge only displays data for the current date.

      Can anyone suggest me a better way?

      Thank you,

      Jose.