Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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