topic Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/601108#M546957 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I have a Pivot Table in which the plant wise sum of the amount is shown.when i select a Plant from the table it will show only the amount for that plant . But when i select the model from the table the selection should work for other reports but the table should remain as same.</P><P></P><P>Thnks in advance...</P><P></P><P><IMG alt="Pivot.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/54294_Pivot.png" style="width: 620px; height: 314px;" /></P></BODY></HTML> Wed, 05 Mar 2014 04:29:43 GMT 2014-03-05T04:29:43Z Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/601108#M546957 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I have a Pivot Table in which the plant wise sum of the amount is shown.when i select a Plant from the table it will show only the amount for that plant . But when i select the model from the table the selection should work for other reports but the table should remain as same.</P><P></P><P>Thnks in advance...</P><P></P><P><IMG alt="Pivot.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/54294_Pivot.png" style="width: 620px; height: 314px;" /></P></BODY></HTML> Wed, 05 Mar 2014 04:29:43 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/601108#M546957 2014-03-05T04:29:43Z Re: Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/601109#M546958 <HTML><HEAD></HEAD><BODY><P>Yes .You can use Sum(<STRONG>{1}</STRONG> Amount).Then it will always shows all the data and will not respond to any selections</P></BODY></HTML> Wed, 05 Mar 2014 04:33:44 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/601109#M546958 chiru_thota 2014-03-05T04:33:44Z Re: Pivot Table https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/601110#M546959 <HTML><HEAD></HEAD><BODY><P>Thnk You... .:)</P></BODY></HTML> Wed, 05 Mar 2014 04:39:24 GMT https://community.qlik.com/t5/QlikView/Pivot-Table/m-p/601110#M546959 2014-03-05T04:39:24Z