Range Selection in Set Modifier?

[robinrouleur]

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

[marcus_sommer]

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

[robinrouleur · Accepted solution]

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