topic FirstSortedValue shows multiple results in straight table in QlikView

FirstSortedValue shows multiple results in straight table

timmoe11 — Thu, 11 Aug 2022 18:59:35 GMT

Hi There!

i think i'm a little lost right now.. maybe i think way to complicate.

I'd like to lookup the Bin Code with the highest quantity in stock for managing our replenishment.

dimension: itemno (key field between item-table and bincontent-table)

Formula used:

FirstSortedValue([LP.Bin Code], -Aggr(sum(LP.Quantity),[LP.Bin Code]))

FirstSortedValue(LP.Quantity, -Aggr(sum(LP.Quantity),[LP.Bin Code]))

results are ok, when i select a single itemno in the app. as soon as i unselect the itemno, results in the straight table are mad..

any idea what i'm doing wrong? do i have to set this up in load script? any idea how? thank you!

Tim

BrunPierre — Thu, 11 Aug 2022 20:40:00 GMT

Maybe by adding the itemno as a dimension.

timmoe11 — Fri, 12 Aug 2022 06:13:34 GMT

itemno is a dimension in both charts..

BrunPierre — Fri, 12 Aug 2022 06:23:12 GMT

I meant as part of the expressions

FirstSortedValue([LP.Bin Code], -Aggr(sum(LP.Quantity),[LP.Bin Code],itemno))

FirstSortedValue(LP.Quantity, -Aggr(sum(LP.Quantity),[LP.Bin Code],itemno))