topic AGGR in QlikView

AGGR

johnan — Sat, 16 Nov 2024 02:13:05 GMT

Hi, what im missing out here?

I want the highlighed post to tell me "+-" on both.

I'ts same order, sku and the sum is 0

The expression is now:

aggr(if(Sum(QUANO = '0'),'+-','N/A'),SHPPO,PRDNO)

martinpohl — Wed, 16 Oct 2019 07:53:25 GMT

because quano also is a field in the table, the calculation is done also for the individual field

I suggest

aggr(if(Sum(total <SHPPO,PRDNP> QUANO) = '0','+-','N/A'),SHPPO,PRDNO)

johnan — Wed, 16 Oct 2019 07:56:34 GMT

yeah, one step closer 🙂

I want even the first post to show +-

johnan — Wed, 16 Oct 2019 08:12:16 GMT

Found it

aggr(if(Sum(total <SHPPO,PRDNO> QUANO) = '0','+-','N/A'),SHPPO,PRDNO,QUANO)

Thanx 🙂