3 Replies Latest reply: Jan 10, 2012 4:08 AM by ravimandre RSS

    How to Create custom variable and use them in other expressions

      Hi All ,

       

      This is Ravindra Mandre and just before sometime started working on qlikview  and obviously new to it.

      While doing some table operations I came to a requirement of creating some custom variables that can be used in other calculations and other expressions which includes the use of created varibles . for example

       

      I wanted to create one variable which will do some calculation like this 

      output_a= Count(variable_a) or AVG(variable_a)

      and then variable_a does some other calculations like 

       

      variable_a = if(someDate=Now(2) and otherDate=SOME_OTHER_DATE, true , false);

       

      So my question is that How I can create the custom variables so that I can use them into my calculations without repeating the same calculations again and again.

       

      Please help .

       

      Thanks & Regards

      Ravindra Mandre