topic Re: How to do calculation? in QlikView https://community.qlik.com/t5/QlikView/How-to-do-calculation/m-p/400006#M1155755 <HTML><HEAD></HEAD><BODY><P>Qlikview will make auto join based on common clos in both the tabel.in expersion you just write % logic on filed</P></BODY></HTML> Wed, 27 Mar 2013 14:37:49 GMT srinivasa1 2013-03-27T14:37:49Z How to do calculation? https://community.qlik.com/t5/QlikView/How-to-do-calculation/m-p/400005#M1155754 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am new to Qlikview. </P><P></P><P>Now, i am trying to create some sample reports in qlikview for my project. That report, contains data from 4 tables. I am joining those tables inside qlikview using Load commands like this </P><P></P><P>I want to calculate the percentage of 2 fields from different tables ( different load)</P><P></P><P>How to do that?</P></BODY></HTML> Wed, 27 Mar 2013 14:26:23 GMT https://community.qlik.com/t5/QlikView/How-to-do-calculation/m-p/400005#M1155754 2013-03-27T14:26:23Z Re: How to do calculation? https://community.qlik.com/t5/QlikView/How-to-do-calculation/m-p/400006#M1155755 <HTML><HEAD></HEAD><BODY><P>Qlikview will make auto join based on common clos in both the tabel.in expersion you just write % logic on filed</P></BODY></HTML> Wed, 27 Mar 2013 14:37:49 GMT https://community.qlik.com/t5/QlikView/How-to-do-calculation/m-p/400006#M1155755 srinivasa1 2013-03-27T14:37:49Z Re: How to do calculation? https://community.qlik.com/t5/QlikView/How-to-do-calculation/m-p/400007#M1155756 <HTML><HEAD></HEAD><BODY><P>Hi Shriram can you please give me a sample code ?</P><P></P><P>I want to use "SEG_CY_VOLUME" from last table (<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">DYF_SEGMENT_SALES</SPAN>) and&nbsp; "<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">CY_VOLUME</SPAN>" from 4th table (<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">DYF_VEHICLE_SALES</SPAN>)</P><P></P><P>I tried adding the % logic in the first load but got an error like the field is not available.</P></BODY></HTML> Wed, 27 Mar 2013 14:44:03 GMT https://community.qlik.com/t5/QlikView/How-to-do-calculation/m-p/400007#M1155756 2013-03-27T14:44:03Z Re: How to do calculation? https://community.qlik.com/t5/QlikView/How-to-do-calculation/m-p/400008#M1155757 <HTML><HEAD></HEAD><BODY><P>You need use concatenate or resident tabel concept. so you make single table and apply % logic or you can upload you sample app.</P></BODY></HTML> Wed, 27 Mar 2013 20:52:35 GMT https://community.qlik.com/t5/QlikView/How-to-do-calculation/m-p/400008#M1155757 srinivasa1 2013-03-27T20:52:35Z Re: How to do calculation? https://community.qlik.com/t5/QlikView/How-to-do-calculation/m-p/400009#M1155758 <HTML><HEAD></HEAD><BODY><P>Surenther,</P><P>Upload an sample document.</P></BODY></HTML> Thu, 28 Mar 2013 12:47:45 GMT https://community.qlik.com/t5/QlikView/How-to-do-calculation/m-p/400009#M1155758 2013-03-28T12:47:45Z