Set Analysis is giving error

Tue, 10 May 2016 12:44:29 GMT

Hi,

As I am trying to run st analysis for my one of the task but when I am creating it it shows error indication near curly bracket of kCommodity_ID so can anyone help me in this regards. I am pasting the script below:

=fabs(Sum( {<GetCurrentField( {kCommodity_ID)='$(=Commodity_ID)')} >= PY1Month_Consumption_Baseline)}* if(Only( {<To_Consumption_UOM_ID={'$(=To_Consumption_ID)'} >} Consumption_Conversion_Factor)<>null(),Only( {<To_Consumption_UOM_ID={'$(=To_Consumption_ID)'} >} Consumption_Conversion_Factor ),1)

Re: Set Analysis is giving error

trdandamudi — Tue, 10 May 2016 17:33:46 GMT

See below for the correct expression:

=fabs(Sum( {<GetCurrentField( kCommodity_ID)={'$(=Commodity_ID)')} >= PY1Month_Consumption_Baseline)}* if(Only( {<To_Consumption_UOM_ID={'$(=To_Consumption_ID)'} >} Consumption_Conversion_Factor)<>null(),Only( {<To_Consumption_UOM_ID={'$(=To_Consumption_ID)'} >} Consumption_Conversion_Factor ),1)

topic Set Analysis is giving error in QlikView

Set Analysis is giving error

Re: Set Analysis is giving error