https://community.qlik.com/t5/QlikView/how-to-write-if-condition-on-the-script-without-loading-the-data/m-p/1622205#M734504 <P>Hi,</P><P>&nbsp;</P><P>try with the file attached</P> Tue, 10 Sep 2019 15:12:05 GMT StarinieriG 2019-09-10T15:12:05Z https://community.qlik.com/t5/QlikView/how-to-write-if-condition-on-the-script-without-loading-the-data/m-p/1622184#M734503 <P>Hello,<BR /><BR />I have the data as&nbsp; attached below.<BR />I need to calculate the total and company sales based on the code by writing on the script. I cannot use Inline function because I have huge data.<BR /><STRONG>For code (1530) the sales should be sum of sales for code (1530)-code (1547)-code (15500140)-code (15500240)-code (15904001)-Code(15904002)-code (15904003)</STRONG><BR />Both Company and Total should be calculated like the above expression<BR />Can someone help me to find a solution&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/how-to-write-if-condition-on-the-script-without-loading-the-data/m-p/1622184#M734503 Sarath123 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/how-to-write-if-condition-on-the-script-without-loading-the-data/m-p/1622205#M734504 <P>Hi,</P><P>&nbsp;</P><P>try with the file attached</P> Tue, 10 Sep 2019 15:12:05 GMT https://community.qlik.com/t5/QlikView/how-to-write-if-condition-on-the-script-without-loading-the-data/m-p/1622205#M734504 StarinieriG 2019-09-10T15:12:05Z https://community.qlik.com/t5/QlikView/how-to-write-if-condition-on-the-script-without-loading-the-data/m-p/1622210#M734505 <P>Many Thanks&nbsp;<span class="lia-unicode-emoji" title=":smiling_face_with_smiling_eyes:">😊</span></P> Tue, 10 Sep 2019 15:23:29 GMT https://community.qlik.com/t5/QlikView/how-to-write-if-condition-on-the-script-without-loading-the-data/m-p/1622210#M734505 Sarath123 2019-09-10T15:23:29Z https://community.qlik.com/t5/QlikView/how-to-write-if-condition-on-the-script-without-loading-the-data/m-p/1622674#M734506 <P>For the below data where both codes were mentioned</P> Wed, 11 Sep 2019 14:04:08 GMT https://community.qlik.com/t5/QlikView/how-to-write-if-condition-on-the-script-without-loading-the-data/m-p/1622674#M734506 Sarath123 2019-09-11T14:04:08Z https://community.qlik.com/t5/QlikView/how-to-write-if-condition-on-the-script-without-loading-the-data/m-p/1622687#M734507 <P>Try to see the new file attached.</P><P>&nbsp;</P><P>Now you have multiple fields for each code</P> Wed, 11 Sep 2019 14:22:48 GMT https://community.qlik.com/t5/QlikView/how-to-write-if-condition-on-the-script-without-loading-the-data/m-p/1622687#M734507 StarinieriG 2019-09-11T14:22:48Z