How to use Between function in Qliksense

[rvijayanth]

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

[shraddha_g · Accepted solution]

Try:

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

[rvijayanth]

Thank you so much

[rvijayanth]

One more question, what if I want to show the dimension in my pivot table as years but only years between 'from' and 'to' years?

Something like this????

if([Year]={">$(vFrom) and <=$(vTo)"}), [Year])

[shraddha_g]

instead use set analysis in all expressions of Pivot table ({<[Year]={">$(vFrom)<=$(vTo)"}>}

and in Add Ons Section uncheck Show zero values.

It will restrict year in dimension according to values mentioned in set analysis

[rvijayanth]

I want to use in dimension so that when users use the slider to set from and to values, the values show up as selections on the selection bar.

So please tell me if this can be used to restrict dimensions?

[shraddha_g]

try

if([Year]>='$(vFrom)' and [Year]<='$(vTo)', [Year])

[rvijayanth]

Thank you so much. This is what I want although I realize i like the expression on the count is better.