Apply FirstSortedValue to receipt-position

Thu, 21 May 2015 13:01:39 GMT

Hi,

for a customer I want to get to get the turnover value of the highest ranking position from all filtered receipts.

I use the Aggr function together with the FirstSortedValue function to determine the turnover. I get the right value but it appears behind the wrong receipt position.

Function:

SUM(

Aggr( FirstSortedValue(

GesamtUmsatz, -Restbon_Sortierung , 1)

, Bonnummer

)

GesamtUmsatz = turnover

Restbon_Sortierung = receipt position ranking (every position on each receipt is ranked with a unique value on the receipt)

Bonnummer = receipt number (every receipt got a unique number)

Example:

there are 9 position on a receipt, 5 of them have the subcategory 'L' (wich is selected / filtered), the highest ranking of theese 5 Positions is 'Product J' with a turnover of 7€. However, this value is displayed behind the first of the 5 selected positions ('Product F').

(It is all in the attachment)

Question:

How do I get the Value behind its corresponding position ('Product F')?

This is driving my crazy, any help is very much appreciated.

topic Apply FirstSortedValue to receipt-position in QlikView

Apply FirstSortedValue to receipt-position