7 Replies Latest reply: Dec 13, 2016 1:20 AM by Vijayanth radha RSS

    How to use Between function in Qliksense

    Vijayanth radha

      I have a pivot table with distinct count of ID as a measure. I want to be able to count ID when its "Between" "From" and "To".

       

      Whats the syntax for using between logic?

       

      Will something like the following work?

       

      Count({<[Year]={">$(vFrom)"} and [Year]={">=$(vTo)"}>} Distinct ID)???