Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is also one interview Question...........
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 )
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 )
Hi,
try this if this work:
sum({<Date01= {'<=$(=vToday) >=$(=vTomorrow)'}> } Amount)
Regards.
sum( {$<Year = {“>1978<2004”}>} Sales )
I have used between values in qlikview in the past and I used it as Peter mentioned it...