3 Replies Latest reply: Apr 8, 2016 9:19 AM by abhay singh RSS

    Character's limit to write the Expresssion in Qliksense

    abhay singh

      Hi Guys,

       

      I am facing few new challenge in Qliksense while writing the Expressions in Qliksense

      1= I am not able to write the lengthy expression, reason facing the Character limit issue. After one limit not able to write the expressions.

       

      2= Variables not working properly

      i.e.

      a = Recent issue is , i have one condition ,

      if( sum(Value) >  ( stock-  ( $(Variable1) - $(Variable2) ),1,0)

           this simple logic is not working, Reason i seen in this is  ($(Variable1) - $(Variable2) returning me Null.

       

      Example2 = $(Stock)- ($(D1)  + $(D2)  + $(D3)  ) = output = null or invalid

      $(Stock)- $(D1)  - $(D2)  - $(D3)   = output = Getting proper output, But according to me both condition should work.

       

      b=

      SET vTest = 1+2;

      If I use $(vTest) it will return 3.

      But if I use ($(vTest)) it will return Null.

       

      Pls suggest.. Any input on this will be appreaciated

       

       

      Reg..

      Abhay