5 Replies Latest reply: Oct 28, 2011 11:14 AM by esepulveda RSS

    Inserting variable in script to be evaluated later in dimmension

      Hi, I have a problem trying to insert a variable into a static table, then try to evaluate its value in runtime, but I keep getting errors.

       

      Here's the scenario:

       

      Step 1- Load a tatic table with the dynamic value

       

      StaticTable:

                          NOCONCATENATE

                          LOAD * INLINE [

               DimDef, "IF($(var1)=0, 1, 0)"

                          ];

       

      Step 2 - Use the field's value as a Calculated Dimension Expression:

       

      $(=DimDef)

       

       

      Result:

       

      When I Load the data, the expression of the column is evaluated prior setting the dimension definition, and the static table's row has the following:

       

      StaticTable:

      DimDef

      "IF(1=0)=0, 1, 0"

       

      So, the value neves changes, since the variable was evaluated at load time, not in at "chart time"

       

      I tried to play around with this approach and replacing the quotes but didnt worked:

       

      http://community.qlik.com/message/59213#59213

       

      Any Suggestion so I can enter "IF($(var1)=0, 1, 0)" in my static table and it goes untouched to my chart's calculated dimmension, so at the end, the expression will be calculated in runtime?

       

      Thanks in advance for the time

       

      -ed