topic Pivot Table making in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-making/m-p/839562#M1006898 <HTML><HEAD></HEAD><BODY><P style="color: #444444; font-family: Calibri, sans-serif; font-size: 15px;">Hi,</P><P style="color: #444444; font-family: Calibri, sans-serif; font-size: 15px;"></P><P style="color: #444444; font-family: Calibri, sans-serif; font-size: 15px;"></P><P style="color: #444444; font-family: Calibri, sans-serif; font-size: 15px;">I am trying to achieving something like this in the Total Sales. this is a report combined by two tables. the tables are main sales and Sub sales... i am attaching the three excels.. help me to tell me how it can be done in qlikview....</P><P style="color: #444444; font-family: Calibri, sans-serif; font-size: 15px;"></P><P style="color: #444444; font-family: Calibri, sans-serif; font-size: 15px;">A customer may have values for Main sales and may not have for sub sales also in the vice versa...</P><P style="color: #444444; font-family: Calibri, sans-serif; font-size: 15px;"></P><P style="color: #444444; font-family: Calibri, sans-serif; font-size: 15px;">for eg. customer 'g' have values for for main sales, but not in sub sales and customer 'h' has value in sub sales and not in main sales. both conditions are to be made in the Total Sales.....</P></BODY></HTML> Sat, 23 May 2015 14:44:00 GMT 2015-05-23T14:44:00Z Pivot Table making https://community.qlik.com/t5/QlikView/Pivot-Table-making/m-p/839562#M1006898 <HTML><HEAD></HEAD><BODY><P style="color: #444444; font-family: Calibri, sans-serif; font-size: 15px;">Hi,</P><P style="color: #444444; font-family: Calibri, sans-serif; font-size: 15px;"></P><P style="color: #444444; font-family: Calibri, sans-serif; font-size: 15px;"></P><P style="color: #444444; font-family: Calibri, sans-serif; font-size: 15px;">I am trying to achieving something like this in the Total Sales. this is a report combined by two tables. the tables are main sales and Sub sales... i am attaching the three excels.. help me to tell me how it can be done in qlikview....</P><P style="color: #444444; font-family: Calibri, sans-serif; font-size: 15px;"></P><P style="color: #444444; font-family: Calibri, sans-serif; font-size: 15px;">A customer may have values for Main sales and may not have for sub sales also in the vice versa...</P><P style="color: #444444; font-family: Calibri, sans-serif; font-size: 15px;"></P><P style="color: #444444; font-family: Calibri, sans-serif; font-size: 15px;">for eg. customer 'g' have values for for main sales, but not in sub sales and customer 'h' has value in sub sales and not in main sales. both conditions are to be made in the Total Sales.....</P></BODY></HTML> Sat, 23 May 2015 14:44:00 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-making/m-p/839562#M1006898 2015-05-23T14:44:00Z Re: Pivot Table making https://community.qlik.com/t5/QlikView/Pivot-Table-making/m-p/839563#M1006899 <HTML><HEAD></HEAD><BODY><P>Is this you need?</P><P><IMG alt="p14.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/87407_p14.png" style="height: 272px; width: 620px;" /></P></BODY></HTML> Sun, 24 May 2015 08:14:57 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-making/m-p/839563#M1006899 ecolomer 2015-05-24T08:14:57Z Re: Pivot Table making https://community.qlik.com/t5/QlikView/Pivot-Table-making/m-p/839564#M1006900 <HTML><HEAD></HEAD><BODY><P>the file qv</P></BODY></HTML> Sun, 24 May 2015 08:16:33 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-making/m-p/839564#M1006900 ecolomer 2015-05-24T08:16:33Z Re: Pivot Table making https://community.qlik.com/t5/QlikView/Pivot-Table-making/m-p/839565#M1006901 <HTML><HEAD></HEAD><BODY><P>yes..</P></BODY></HTML> Sun, 24 May 2015 09:19:22 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-making/m-p/839565#M1006901 2015-05-24T09:19:22Z Re: Pivot Table making https://community.qlik.com/t5/QlikView/Pivot-Table-making/m-p/839566#M1006902 <HTML><HEAD></HEAD><BODY><P>Ok,</P><P>can you put answer correct and close </P></BODY></HTML> Sun, 24 May 2015 09:23:08 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-making/m-p/839566#M1006902 ecolomer 2015-05-24T09:23:08Z Re: Pivot Table making https://community.qlik.com/t5/QlikView/Pivot-Table-making/m-p/839567#M1006903 <HTML><HEAD></HEAD><BODY><P>i have also having a strange issue.. i am pulling data from oracle and when i try to reload.. i am getting error like 'odbc read failed'.. </P><P></P><P>you have any such experience?</P><P></P><P>thanks</P><P></P><P>Renjith</P></BODY></HTML> Sun, 24 May 2015 09:28:50 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-making/m-p/839567#M1006903 2015-05-24T09:28:50Z Re: Pivot Table making https://community.qlik.com/t5/QlikView/Pivot-Table-making/m-p/839568#M1006904 <HTML><HEAD></HEAD><BODY><P>No, I haven't this question</P></BODY></HTML> Sun, 24 May 2015 09:31:02 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-making/m-p/839568#M1006904 ecolomer 2015-05-24T09:31:02Z Re: Pivot Table making https://community.qlik.com/t5/QlikView/Pivot-Table-making/m-p/839569#M1006905 <HTML><HEAD></HEAD><BODY><P>ok... thanks....:)</P></BODY></HTML> Sun, 24 May 2015 09:31:39 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-making/m-p/839569#M1006905 2015-05-24T09:31:39Z