topic Regarding Interval Grouping Customizations in QlikView

Regarding Interval Grouping Customizations

Tue, 17 Jun 2014 20:01:02 GMT

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.

=if('Rate'>=.10, '.10<=x<=1.00',class('Rate',0.01))

I would appreciate any help you can provide. Thanks.

Re: Regarding Interval Grouping Customizations

Gysbert_Wassenaar — Wed, 18 Jun 2014 12:32:11 GMT

'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'.

Re: Regarding Interval Grouping Customizations

Wed, 18 Jun 2014 13:08:10 GMT

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.