Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

1 Solution

Accepted Solutions
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.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
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.


talk is cheap, supply exceeds demand
Not applicable
Author

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.

Gysbert_Wassenaar

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;


talk is cheap, supply exceeds demand