Problem with aggr max in straight table - Qlik Community

Report Inappropriate Content · ‎2015-09-23

Hello dear community,

I'm stuck on a silly problem.

I have the following table:

In a straight table I wish to display only the lines which confirm to the following rule:

Max of sequence for a given key.

I tried aggr(max(Sequence),Key), but it is for some weird reason picking out line 1 and 5.

Attached a sample app.

Thank you in advance for getting me unstuck!

Cheers

PrashantSangle · ‎2015-09-23

Hi,

check firstsortedvalue()

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2015-09-23

ok, trying to figure out usage.

sasiparupudi1 · ‎2015-09-23

Remove sequence from your dimensions

hth

Sasi

Report Inappropriate Content · ‎2015-09-23

The expected result is to keep row 6, and 7

jonathandienst · ‎2015-09-23

If you use Aggr() in a table, then all the table dimension should be included in the Aggr()

aggr(max(Sequence),Key,Status,Sequence,product)

(but you need to remove Sequence from the table dimensions and the aggr)

PS the Aggr() is redundant - =Max(Sequence) is enough

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

jonathandienst · ‎2015-09-23

But I think what you are perhaps after is to use the Aggr as a calculated dimension?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Report Inappropriate Content · ‎2015-09-23

Tried it. It's picking out line 1, 5 and 6 ... ?

sasiparupudi1 · ‎2015-09-23

Please remove sequence from dimension and it should give you your result

Report Inappropriate Content · ‎2015-09-23

Sorry i think i didnt express myself clearly.

Actually I dont need the expression field, i'm just using it to sort the table.

The expected result is as follows.

Thank you