Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
johnan
Creator III
Creator III

AGGR

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

clipboard_image_0.png

 

The expression is now:

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

Labels (1)
1 Solution

Accepted Solutions
martinpohl
Partner - Master
Partner - Master

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)

 

View solution in original post

3 Replies
martinpohl
Partner - Master
Partner - Master

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
Creator III
Creator III
Author

yeah, one step closer 🙂

I want even the first post to show +-

 

clipboard_image_0.png

johnan
Creator III
Creator III
Author

Found it

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

clipboard_image_1.png

Thanx 🙂