3 Replies Latest reply: Dec 28, 2012 12:53 PM by Gysbert Wassenaar RSS

    Only the aggregated Row is needed

      Hello QlikView Community,

       

      here my example:

       

      NumberAmounz
      12341,00
      12340,50
      12340,50
      12355,00
      12352,00
      12352,00
      12351,00

       

      I need for my development, only the green Rows. But I don't know how can I extract only the green Rows.

      The green rows are the aggregated rows of the underlying rows.

       

      Do you have any idea?

       

      Thank for your response

        • Re: Only the aggregated Row is needed
          Gysbert Wassenaar

          If those are all rows in the same table, the aggregated values are also the largest. So you could use the max function:

           

          SummaryTable:

          load Number, max(Amounz) as MaxAmounz

          from OriginalTable.qvd (qvd)

          group by Number;

           

          change the from line to something that's right for your situation.

            • Re: Only the aggregated Row is needed

              Sorry I have a understanding problem, here my code:

               

              SET ThousandSep='.';

              SET DecimalSep=',';

              SET MoneyThousandSep='.';

              SET MoneyDecimalSep=',';

              SET MoneyFormat='#.##0,00 €;-#.##0,00 €';

              SET TimeFormat='hh:mm:ss';

              SET DateFormat='DD.MM.YYYY';

              SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';

              SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez';

              SET DayNames='Mo;Di;Mi;Do;Fr;Sa;So';

               

               

              LOAD Number,

                   Amounz

              FROM

              C:\Users\Jörn\Documents\qlikview.xlsx

              (ooxml, embedded labels);

               

               

              If I put the code snipet inside

              "

              SummaryTable:

              load Number, max(Amounz)

              resident OriginalTable group by Number;"

               

              There will be an errormessage no table found.

               

              Where ist the Problem? I don´t find it, I try to find a solution. But no success.

               

              Can you help me.

               

              Thanks.