Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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
Partner

Hi,

maybe you have to add NODISTINCT ?

View solution in original post

2 Replies
bbi_mba_76
Partner
Partner

Hi,

maybe you have to add NODISTINCT ?

View solution in original post

Not applicable
Author

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