topic How to write in QlikView https://community.qlik.com/t5/QlikView/How-to-write/m-p/1013618#M922221 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>From the below sample,</P><P></P><P>How can I get SEP as 144.36<IMG alt="Capture4.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/122611_Capture4.PNG" style="height: 343px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT suvechha_b 2020-11-25T16:16:04Z How to write https://community.qlik.com/t5/QlikView/How-to-write/m-p/1013618#M922221 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>From the below sample,</P><P></P><P>How can I get SEP as 144.36<IMG alt="Capture4.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/122611_Capture4.PNG" style="height: 343px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-write/m-p/1013618#M922221 suvechha_b 2020-11-25T16:16:04Z Re: How to write https://community.qlik.com/t5/QlikView/How-to-write/m-p/1013619#M922222 <HTML><HEAD></HEAD><BODY><P>Use Calculated Dimension for SEP</P><P>=Aggr(Max(TOTAL SEP),[Product Code])</P></BODY></HTML> Mon, 25 Apr 2016 13:27:40 GMT https://community.qlik.com/t5/QlikView/How-to-write/m-p/1013619#M922222 MK_QSL 2016-04-25T13:27:40Z