Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for
Did you mean:
Partner - Creator

## Range Selection in Set Modifier?

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

1 Solution

Accepted Solutions
Partner - Creator
Author

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

2 Replies
MVP & Luminary

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

Partner - Creator
Author

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

Community Browser