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.