Hi, I am very new to Qlikview. I have decimal rates going from 0 to 1. I understand how to group them by intervals. However, I would like to make a custom group that contains all values from .10-1.00 and 10 other fields with .01 intervals between 0 and .10 like .1,.2,.3 etc . I would like to do this on a pivot table. I tried this expression, but it put everything into the custom group .10-1.00.
'Rate' is a character string value, not a field name. So your expression is always comparing the string 'Rate' with the value 0.10. The result of that comparison is always false. Try removing the single quotes around 'Rate'.
Hi Gysbert, sorry for the confusion. Rate is a field since its just a test project. Thanks. I still can't figure out how to create a unique interval group that contains .10-1. Thanks.
