2 Replies Latest reply: Oct 12, 2018 7:46 AM by patrice salem RSS

    greater in expression combined with qsVariable

    patrice salem

      Hello

       

      I'm setting up a Qlik report, using Qlik Desktop and the the qsVariable extension.

      It works great except for an expression where I'm trying to use a > or < comparison

       

      The following works :

      sum({<Week={$(VCurrentWeek)}>} qte_commandee)

       

      As soon as I try to replace the = by <=  (lower than), no data appear in my analysis :

      sum({<Week=<{$(VCurrentWeek)}>}qte_commandee)

       

      I have also tried

      sum({<Week={'<="$(VCurrentWeek)}>}qte_commandee)

      and many other trials...with no luck


      At the same time, I have tried to transform the Week field and the VCurrentWeek into a numeric value (num#) since all my weeks are formated on two digits

      the week field is populated in this way : num(week(order_date),'00')

      The $VCurrentWeek is : num(week(now()),'00')


      So, I gess the first error comes from the proper use of <= in the expression.

      I also guess that I will need to transform the week number filed and variable into a numerica value


      How can I do ?


      Thanks

      pat