5 Replies Latest reply: Mar 20, 2016 10:55 AM by Burkhard Veidl RSS

    Dimensions NOT aggregate

    Ant�nio Vilares

      Hello,

       

      I've this application in attach. I'm trying to build a chart that shows all the days per week. When I'm trying to create it, I obtain this chart:

       

      Capture.PNG
      But I want to tho show all day weeks by Week. Someting like this:

       

      Capture1.PNG

       

      Basically, I want to show all the days from the weeks in chart.

       

       

       

      Thanks!

        • Re: Dimensions NOT aggregate
          Massimo Grossi

          Dimensions

          - Week

          - WeekDay

          1.png

          SET DateFormat='DD/MM/YYYY';

           

          Table:

          LOAD * INLINE

          [

          Team,Num_Goals, Date

          A,3,29/02/16

          B,2,01/03/16

          C,5,02/03/16

          D,2,03/03/16

          E,7,04/03/16

          A,3,07/03/16

          B,2,08/03/16

          C,5,09/03/16

          D,2,10/03/16

          E,7,11/03/16

          A,3,14/03/16

          B,2,15/03/16

          C,5,16/03/16

          D,2,17/03/16

          E,7,18/03/16

          ];

           

          LOAD

          Date,

          WeekDay(Date) as WeekDay,

          Day(Date) as Day,

          Dual('Week ' & wEEK(Date), wEEK(Date)) as Week,

          Month(Date) as Month,

          Year(Date) as Year

          Resident Table;

          • Re: Dimensions NOT aggregate
            Stefan Wühl

            Looks like you just need to change the order of dimensions.

             

            See attached (needed to recreate most, because your sample showed empty sheets and unlinked tables),

            • Re: Dimensions NOT aggregate
              Ruben Marin

              Hi, some things to comment:

              - Your DateFormat variable has different from than the one you have in your inline table, so you need to use Date#() to tell QV the dateformat he is reading.

              - You need to link both tables so I added the Date field to the 2nd table, just with that both tables are linked by date

              - Not absolutely needed, but I renamed some fields of the 2nd table

              - I also added the 'Week' string to the week field, using Dual() to keep the numeric value

               

              With this I created a chart by week and an expression for each day using set analisys, PFA

               

              Edit: as swhuel said, it's easier just switching dimensions, I updated the attachment.