How we can use 'Between' in set analysis?

[#1]

This is also one interview Question...........

[petter · Accepted solution]

You can simply write a set expression that use a "search" and the search is composed of logical operators that implement the between.

Like this

Avg( { < FilmID= { "=Rating>=2 AND Rating<=4" } > Rating )

[Anonymous]

Hi,

try this if this work:

sum({<Date01= {'<=$(=vToday) >=$(=vTomorrow)'}> } Amount)

Regards.

[MK_QSL]

sum( {$<Year = {“>1978<2004”}>} Sales )

[Anonymous]

I have used between values in qlikview in the past and I used it as Peter mentioned it...