2 Replies Latest reply: Jun 18, 2014 9:08 AM by Jimi Hendrix RSS

    Regarding Interval Grouping Customizations

      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.