topic Complicated Pivot table in QlikView https://community.qlik.com/t5/QlikView/Complicated-Pivot-table/m-p/948507#M950723 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hello,</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I have a set of data from excel and I have to represent that in a different way.In the attached QVW I have fields from Excel file(attached) and I have used master calendar to generate month fields.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">We have different phases and based on the month that has to be separated in the table.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Any help is highly appreciated.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Thank you very much.</P></BODY></HTML> Thu, 03 Dec 2015 19:55:01 GMT 2015-12-03T19:55:01Z Complicated Pivot table https://community.qlik.com/t5/QlikView/Complicated-Pivot-table/m-p/948507#M950723 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hello,</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I have a set of data from excel and I have to represent that in a different way.In the attached QVW I have fields from Excel file(attached) and I have used master calendar to generate month fields.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">We have different phases and based on the month that has to be separated in the table.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Any help is highly appreciated.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Thank you very much.</P></BODY></HTML> Thu, 03 Dec 2015 19:55:01 GMT https://community.qlik.com/t5/QlikView/Complicated-Pivot-table/m-p/948507#M950723 2015-12-03T19:55:01Z Re: Complicated Pivot table https://community.qlik.com/t5/QlikView/Complicated-Pivot-table/m-p/948508#M950725 <HTML><HEAD></HEAD><BODY><P>Pavana,</P><P></P><P>What exactly is it that you want to acheive? I'm sorry but your question is quite vague?</P></BODY></HTML> Thu, 03 Dec 2015 20:55:15 GMT https://community.qlik.com/t5/QlikView/Complicated-Pivot-table/m-p/948508#M950725 nico_ilog 2015-12-03T20:55:15Z Re: Complicated Pivot table https://community.qlik.com/t5/QlikView/Complicated-Pivot-table/m-p/948509#M950726 <HTML><HEAD></HEAD><BODY><P>PFA attached this is what your are looking</P><P></P><P>Vikas</P></BODY></HTML> Fri, 04 Dec 2015 08:59:59 GMT https://community.qlik.com/t5/QlikView/Complicated-Pivot-table/m-p/948509#M950726 vikasmahajan 2015-12-04T08:59:59Z Re: Complicated Pivot table https://community.qlik.com/t5/QlikView/Complicated-Pivot-table/m-p/948510#M950727 <HTML><HEAD></HEAD><BODY><P>Add some records for changing and test it</P><P></P><P>Vikas</P></BODY></HTML> Fri, 04 Dec 2015 09:00:59 GMT https://community.qlik.com/t5/QlikView/Complicated-Pivot-table/m-p/948510#M950727 vikasmahajan 2015-12-04T09:00:59Z