2 Replies Latest reply: Jan 27, 2016 6:35 AM by guillaume buffry RSS

    Set expressions filtered by variable

      Dear Qlikview masters!


      I am struggling on a case related to expressions evaluation.

      My dataset is as following "Partners", "Forecast_Period" [0 to n], "Certified Value" and a toggle button to show or not the forecast [1 to n]


      on my toggle button I did set the following action v_toggle_forecast=if(v_toggle_forecast=0,1,0)


      a reusable filter as following : set v_Filter_Forecast = if(v_toggle_forecast,0,'*');


      and a sum expression : set e_Liquidity_test = sum({<[Forecast_Period]={$(v_Filter_Forecast)}>} [Certified Value]);


      if I put that expression in a graph diretly it works :-)

      if i have it in the script and call it in the graph using $(e_Liquidity_test) is doesn't :-(


      In what order these expressions get expanded and evaludated?

      Where is my mistake?


      Thanks for your help!