topic Re: Only the aggregated Row is needed in QlikView

Only the aggregated Row is needed

Fri, 28 Dec 2012 15:46:00 GMT

Hello QlikView Community,

here my example:

Number	Amounz
1234	1,00
1234	0,50
1234	0,50
1235	5,00
1235	2,00
1235	2,00
1235	1,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 — Fri, 28 Dec 2012 15:49:39 GMT

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

Fri, 28 Dec 2012 17:10:15 GMT

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.

Re: Only the aggregated Row is needed

Gysbert_Wassenaar — Fri, 28 Dec 2012 17:52:34 GMT

You forgot to give your first table a name:

OriginalTable:

LOAD Number,

Amounz

FROM

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

(ooxml, embedded labels);

SummaryTable:

load Number, max(Amounz) as MaxAmounz

resident OriginalTable group by Number;