AGGR function returns value only on first row of chart

Tue, 11 Feb 2014 16:34:49 GMT

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?

Re: AGGR function returns value only on first row of chart

bbi_mba_76 — Tue, 11 Feb 2014 16:47:49 GMT

Hi,

maybe you have to add NODISTINCT ?

Re: AGGR function returns value only on first row of chart

Tue, 11 Feb 2014 17:02:55 GMT

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

topic AGGR function returns value only on first row of chart in QlikView

AGGR function returns value only on first row of chart

Re: AGGR function returns value only on first row of chart

Re: AGGR function returns value only on first row of chart