Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

AGGR function returns value only on first row of chart

I have a chart with a calculated dimension and each expression uses a pick(match()) function to use a different expression for each dimension.  I have run into a problem with a new function which is below.  It will only return a value in the chart at the first row in the chart.  So if i put the function in the second row pick(match()) slot, it will return null because it is not the first row in the chart.

aggr( if(round(($(vTxnBucketAgg('Buys',[Lower Of SP-Moody],BASE_MKT_VALUE)))/($(vTxnBucketExclusionAgg('Buys',[Lower Of SP-Moody],BASE_MKT_VALUE)))) = ORDER_ID, sp_rc_dual),

  ORDER_ID)

We can simplify the above and just say aggr(if( 3 = order_id, sp_rc_dual), order_id)

The calculated dimension on this chart is a value list:

ValueList(

'Begin',

'Buys',

'Sells',

'End'

)

Is anyone aware of a reason or way to work around this restriction to get these values to display at all rows so they will pick up in the pick(match()) expressions?

1 Solution

Accepted Solutions
bbi_mba_76
Partner - Specialist
Partner - Specialist

Hi,

maybe you have to add NODISTINCT ?

View solution in original post

2 Replies
bbi_mba_76
Partner - Specialist
Partner - Specialist

Hi,

maybe you have to add NODISTINCT ?

Not applicable
Author

It's the simple things in life.  Thanks so much