https://community.qlik.com/t5/QlikView/grouping/m-p/1868602#M1216461 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/159042">@teobt14</a>,</P> <P>You can simply create a field on script level or create a variable like below</P> <P>if(filed&lt;100,'&lt;100','&gt;100') as Group&nbsp;</P> Thu, 09 Dec 2021 12:14:21 GMT abhijitnalekar 2021-12-09T12:14:21Z https://community.qlik.com/t5/QlikView/grouping/m-p/1868536#M1216454 <P>Hi there,</P> <P>I want to group more records, for example I have a Safety Stock Level fields with the following records: 4,60, 100, 200 etc.</P> <P>I want make a new group to include 4 and 60 and name it &lt;100. Then I want to put all records in a pivot table.</P> <P>How do I do that?</P> <P>Thank you in advance!</P> Thu, 09 Dec 2021 10:28:40 GMT https://community.qlik.com/t5/QlikView/grouping/m-p/1868536#M1216454 teobt14 2021-12-09T10:28:40Z https://community.qlik.com/t5/QlikView/grouping/m-p/1868602#M1216461 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/159042">@teobt14</a>,</P> <P>You can simply create a field on script level or create a variable like below</P> <P>if(filed&lt;100,'&lt;100','&gt;100') as Group&nbsp;</P> Thu, 09 Dec 2021 12:14:21 GMT https://community.qlik.com/t5/QlikView/grouping/m-p/1868602#M1216461 abhijitnalekar 2021-12-09T12:14:21Z