https://community.qlik.com/t5/QlikView/how-to-write-an-expression-in-pivot-table-without-change-its/m-p/1589729#M738382 <P>Hi all&nbsp;</P><P>i have a pivot table and year selector,if i select the year selector then in pivot table outstand fields are changing to zero, i had used set analysis but does not&nbsp; work,my requirement is to show static values for that field,can anyone know how to do this?</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT venkat1 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/how-to-write-an-expression-in-pivot-table-without-change-its/m-p/1589729#M738382 <P>Hi all&nbsp;</P><P>i have a pivot table and year selector,if i select the year selector then in pivot table outstand fields are changing to zero, i had used set analysis but does not&nbsp; work,my requirement is to show static values for that field,can anyone know how to do this?</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/how-to-write-an-expression-in-pivot-table-without-change-its/m-p/1589729#M738382 venkat1 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/how-to-write-an-expression-in-pivot-table-without-change-its/m-p/1589730#M738383 <P>Change all the measures that you use in the pivot table. Change for example sum(Amount) to sum({1} Amount). The {1} part will make the measure ignore any and all selections the user makes.</P> Sat, 08 Jun 2019 06:51:35 GMT https://community.qlik.com/t5/QlikView/how-to-write-an-expression-in-pivot-table-without-change-its/m-p/1589730#M738383 Gysbert_Wassenaar 2019-06-08T06:51:35Z