concat aggr?

n1ef5ng1 — Wed, 01 Oct 2014 01:11:37 GMT

I have a complex formula to derive a certain value based on aggr

If ( VPERF_Inter_Gateway_Barge_Indicator = 'X',

Sum ( Aggr ( Sum ( VPERF_Total_Moves * VPERF_Vessel_Rate ), text($(Concat ( _Dimension_Pick,','))) ))

Sum ( Aggr ( Sum ( VPERF_Total_Moves ), text($(Concat ( _Dimension_Pick,','))) ))

)

_Dimension_Pick is a selection for user to select

_Dimension_Pick:

LOAD * INLINE [

_Dimension_Pick

Box,

TEU,

Year,

Month,

Terminal_Id,

Vessel_Type,

];

Based on user selection, the aggr selection will show tweak to achieve the correct formula.

however, based on the expression above, it gives an error as it is unable to read text($(Concat ( _Dimension_Pick,','))) whileas textbox does when i insert the code. any reason why

Re: concat aggr?

Gysbert_Wassenaar — Wed, 01 Oct 2014 14:12:00 GMT

Try $(=Concat( _Dimension_Pick,',')) so that the concat is calculated outside the context of the rest of the expression. Coincidentally I just posted something similar here: Conditional show Straight table based on number of rows. Perhaps you can use that example to see how/that it works.

topic Re: concat aggr? in QlikView

concat aggr?

Re: concat aggr?