Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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) 

1 Reply
trdandamudi
Master II
Master II

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)