topic Re: field max in the table in QlikView

field max in the table

Fri, 12 Dec 2014 09:45:35 GMT

hello,
I have a table of QlikView this:

I need to turn this table by display only the row with the maximum value of the field cost with the aggregation on the field A.

in this way:

What kind of transformations / expressions should I enter?

Thanks
Alex

mato32188 — Fri, 12 Dec 2014 09:50:46 GMT

Hi Alessandro,

switch it to straight table and create expression max(value).

yduval75 — Fri, 12 Dec 2014 09:52:30 GMT

Hello

You can try with firstsortedvalue function.

MK_QSL — Fri, 12 Dec 2014 10:08:37 GMT

Create a table

Dimension

Expression

=FirstSortedValue(Distinct B, -Aggr(SUM(costo),A,B))

=FirstSortedValue(Distinct data, -Aggr(SUM(costo),A,B))

=FirstSortedValue(Distinct Aggr(SUM(costo),A,B), -Aggr(SUM(costo),A,B))

Fri, 12 Dec 2014 11:06:31 GMT

that way I lose the information of the field b.
Could you write me an example.
Thank you very much
Alex

Fri, 12 Dec 2014 13:16:49 GMT

I did not understand where I should insert the given expression.
you give me an example explicit about it?
thanks

Alex

MK_QSL — Fri, 12 Dec 2014 13:17:59 GMT

Create a Straight Table

Use

Dimension

and below three different expressions

FOR B

=FirstSortedValue(Distinct B, -Aggr(SUM(costo),A,B))

FOR data

=FirstSortedValue(Distinct data, -Aggr(SUM(costo),A,B))

For SUM(costo)

=FirstSortedValue(Distinct Aggr(SUM(costo),A,B), -Aggr(SUM(costo),A,B))