topic Range Selection in Set Modifier? in QlikView

Range Selection in Set Modifier?

robinrouleur — Wed, 28 Jan 2015 02:31:56 GMT

Can anyone confirm the data types supported in set modifier range selections? I am trying to get it to work for time intervals but I get a result of 0 every time. A bit of experimentation suggests that it only works for integers but I can't find any clarification, either in QlikView Help or the Community.

My expression is of the form:

Sum({$<IntervalField={'>0'}>} Counter)

Thx

Robin

Re: Range Selection in Set Modifier?

marcus_sommer — Wed, 28 Jan 2015 02:51:46 GMT

With the single-quotes you performs a string-matching and not a numeric-matching but the string-interpretation from modifier is important, too. Example: a month-field with jan - dec wouldn't match in set analysis compared with values from 1 - 12 (but in a if-loop). Therefore try this:

Sum({$<IntervalField={">0"}>} Counter)

Sum({$<IntervalField={">$(=num(0, 'YourFieldFormat'))"}>} Counter)

- Marcus

Re: Range Selection in Set Modifier?

robinrouleur — Wed, 28 Jan 2015 03:20:15 GMT

Fantastic, thanks Marcus, had to use interval() rather than num() but that did the trick!

Final expression was:

Sum({$<IntervalField={">$(=interval(0, 'h:mm:ss'))"}>} Counter)

Thx again (especially or the quick response)

Robin