Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

n1ef5ng1
Contributor

concat aggr?

Hi

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

1 Reply

Re: concat aggr?

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.


talk is cheap, supply exceeds demand
Community Browser