topic Customized report in QlikView https://community.qlik.com/t5/QlikView/Customized-report/m-p/530821#M482225 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>We need to create a report from a source with five columns: GL_cate (GL Category), GL_Code, Branch_Cat (Branch category), Branch (Branch name) and the Amount (Sum of the corresponding sale amount). Please refer the attached excel file(Date.xls) containing it.</P><P></P><P>The report output will be like the same as in the attached excel file: Resultset.xls.</P><P></P><P>Clearly the output contains the GL_cate, GL_Code and the Branch as the dimension and the SUM(Amount) as the expression then the branches are put horizontally with an additional column % for each branch. (N.B. in the attached Resultset file the % column is&nbsp; shown for the first 2 branches only but in reality it will be repeated for the rest of the branches too.)</P><P></P><P>Now the problem is the to calculate the values under the % column. Where the % for each branch will be calculated as the sum of the sales amount of that branch divided by that of the "Sales fruit products" GL_code.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Mon, 26 Aug 2013 13:02:48 GMT Anonymous 2013-08-26T13:02:48Z Customized report https://community.qlik.com/t5/QlikView/Customized-report/m-p/530821#M482225 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>We need to create a report from a source with five columns: GL_cate (GL Category), GL_Code, Branch_Cat (Branch category), Branch (Branch name) and the Amount (Sum of the corresponding sale amount). Please refer the attached excel file(Date.xls) containing it.</P><P></P><P>The report output will be like the same as in the attached excel file: Resultset.xls.</P><P></P><P>Clearly the output contains the GL_cate, GL_Code and the Branch as the dimension and the SUM(Amount) as the expression then the branches are put horizontally with an additional column % for each branch. (N.B. in the attached Resultset file the % column is&nbsp; shown for the first 2 branches only but in reality it will be repeated for the rest of the branches too.)</P><P></P><P>Now the problem is the to calculate the values under the % column. Where the % for each branch will be calculated as the sum of the sales amount of that branch divided by that of the "Sales fruit products" GL_code.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Mon, 26 Aug 2013 13:02:48 GMT https://community.qlik.com/t5/QlikView/Customized-report/m-p/530821#M482225 Anonymous 2013-08-26T13:02:48Z Re: Customized report https://community.qlik.com/t5/QlikView/Customized-report/m-p/530822#M482226 <HTML><HEAD></HEAD><BODY><P>See attached qvw</P></BODY></HTML> Mon, 26 Aug 2013 14:29:29 GMT https://community.qlik.com/t5/QlikView/Customized-report/m-p/530822#M482226 Gysbert_Wassenaar 2013-08-26T14:29:29Z Re: Customized report https://community.qlik.com/t5/QlikView/Customized-report/m-p/530823#M482227 <HTML><HEAD></HEAD><BODY><P>Hi Wassenaar,</P><P>Thank you very much for your prompt reply. We've seen your application as attached by you. This helped us much to resolve the problem. Sorry for the delayed feedback.</P><P>Again thanks a lot!</P><P></P><P>Best regards,</P><P>Dilip</P></BODY></HTML> Mon, 02 Sep 2013 10:24:33 GMT https://community.qlik.com/t5/QlikView/Customized-report/m-p/530823#M482227 Anonymous 2013-09-02T10:24:33Z