12 Replies Latest reply: Sep 2, 2016 7:59 AM by Sunny Talwar RSS

    How to use variables in If clause in expressions!

    hari reddy

      Hi,

      As I am a newbie to Qlikview I have a doubt of how to use variables prdefined in if clause in expressions.

      Here is my statement :

      =Sum(If(Interval(delivered_time-order_time,'mm')>=vDelivered,if(Interval(delivered_time-order_time,'mm')<=vDelivered_upper,1,0),0)

       

      Where vDelivered and vDelivered_upper  are lower and upper ranges used as variables in slider object.

      I can't understand where I am doing mistake.