8 Replies Latest reply: Mar 14, 2018 5:02 PM by Frank Cecconi RSS

    Qlik Sense Variable Help

    Frank Cecconi

      I am having a little issue

       

      I have a variable that allows the user to input a date (vTodate).

       

      I then have variable (test) that converts the input to a number             =Num(Date(vToDate,'M/D/YYYY'))

       

      In my load script, I am doing             Num(Date(TransactionDate,'M/D/YYYY'))                        as TransDateNum

       

      I created 1 more variable (Include)                                                        =if(TransDateNum < $(test) ,'L','G')

       

      The value is never L

       

      Thanks for your assistance.