https://community.qlik.com/t5/Qlik-Automate/How-to-group-data-in-Stright-table/m-p/2471872#M4370 <P>Hi, I'm not sur e of the needs but I think you can solve them using Above(), like:</P> <P>If(Region&lt;&gt;Above(TOTAL Region), [<EM>Expression</EM>])</P> <P>So it only calculates the expression when region is different from the row above.</P> Sat, 20 Jul 2024 11:20:52 GMT rubenmarin 2024-07-20T11:20:52Z https://community.qlik.com/t5/Qlik-Automate/How-to-group-data-in-Stright-table/m-p/2471637#M4364 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SupriyaEllgode_0-1721368187452.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/169594i02749330E8899FF6/image-size/medium?v=v2&amp;px=400" role="button" title="SupriyaEllgode_0-1721368187452.png" alt="SupriyaEllgode_0-1721368187452.png" /></span></P> <P>I want region name should be printed once in first column and in second column its related district.</P> <P>Please help me out to solve this .</P> <P>Thank you</P> <P>&nbsp;</P> Fri, 19 Jul 2024 05:54:27 GMT https://community.qlik.com/t5/Qlik-Automate/How-to-group-data-in-Stright-table/m-p/2471637#M4364 SupriyaEllgode 2024-07-19T05:54:27Z https://community.qlik.com/t5/Qlik-Automate/How-to-group-data-in-Stright-table/m-p/2471872#M4370 <P>Hi, I'm not sur e of the needs but I think you can solve them using Above(), like:</P> <P>If(Region&lt;&gt;Above(TOTAL Region), [<EM>Expression</EM>])</P> <P>So it only calculates the expression when region is different from the row above.</P> Sat, 20 Jul 2024 11:20:52 GMT https://community.qlik.com/t5/Qlik-Automate/How-to-group-data-in-Stright-table/m-p/2471872#M4370 rubenmarin 2024-07-20T11:20:52Z