topic **How to remove multiple rows in pivot table??** in QlikView https://community.qlik.com/t5/QlikView/How-to-remove-multiple-rows-in-pivot-table/m-p/888342#M1008594 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>In a pivot table when i select a year i want the sales for previous,current and next years to be displayed like below.</P><P><IMG alt="Capture2.PNG" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/85830_Capture2.PNG" style="height: auto;" /></P><P></P><P>But when i add expressions for previous and next year sales am getting mutliple rows of sales for 2014Sales and 2015Sales</P><P><IMG alt="Capture1.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/85829_Capture1.PNG" style="height: auto;" /></P><P></P><P>Can someone please help me fix this.</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 06 May 2015 15:10:30 GMT Anonymous 2015-05-06T15:10:30Z **How to remove multiple rows in pivot table??** https://community.qlik.com/t5/QlikView/How-to-remove-multiple-rows-in-pivot-table/m-p/888342#M1008594 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>In a pivot table when i select a year i want the sales for previous,current and next years to be displayed like below.</P><P><IMG alt="Capture2.PNG" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/85830_Capture2.PNG" style="height: auto;" /></P><P></P><P>But when i add expressions for previous and next year sales am getting mutliple rows of sales for 2014Sales and 2015Sales</P><P><IMG alt="Capture1.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/85829_Capture1.PNG" style="height: auto;" /></P><P></P><P>Can someone please help me fix this.</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 06 May 2015 15:10:30 GMT https://community.qlik.com/t5/QlikView/How-to-remove-multiple-rows-in-pivot-table/m-p/888342#M1008594 Anonymous 2015-05-06T15:10:30Z