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)???