Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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.
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;