Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Set Analysis is giving error

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) 

Tags (1)
1 Reply
trdandamudi
Honored Contributor

Re: Set Analysis is giving error

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)


Community Browser