topic Re: How we can use 'Between' in set analysis? in QlikView

How we can use 'Between' in set analysis?

Sat, 04 Jul 2015 06:45:04 GMT

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

petter — Sat, 04 Jul 2015 07:38:53 GMT

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 — Sat, 04 Jul 2015 07:41:15 GMT

Hi,

try this if this work:

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

Regards.

MK_QSL — Sat, 04 Jul 2015 08:31:08 GMT

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

Anonymous — Sat, 04 Jul 2015 09:02:36 GMT

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