topic Variable which is only affected by one filter in QlikView https://community.qlik.com/t5/QlikView/Variable-which-is-only-affected-by-one-filter/m-p/1310082#M407350 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I have looked at having Variables shown in a KPI that does not change when filters are applied</P><P></P><P>avg ({1}A)</P><P></P><P>But I am wondering if you can have it be able to be changed by a single filter such as Year</P><P></P><P>Thank you</P></BODY></HTML> Fri, 14 Jul 2017 11:17:43 GMT Anonymous 2017-07-14T11:17:43Z Variable which is only affected by one filter https://community.qlik.com/t5/QlikView/Variable-which-is-only-affected-by-one-filter/m-p/1310082#M407350 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I have looked at having Variables shown in a KPI that does not change when filters are applied</P><P></P><P>avg ({1}A)</P><P></P><P>But I am wondering if you can have it be able to be changed by a single filter such as Year</P><P></P><P>Thank you</P></BODY></HTML> Fri, 14 Jul 2017 11:17:43 GMT https://community.qlik.com/t5/QlikView/Variable-which-is-only-affected-by-one-filter/m-p/1310082#M407350 Anonymous 2017-07-14T11:17:43Z Re: Variable which is only affected by one filter https://community.qlik.com/t5/QlikView/Variable-which-is-only-affected-by-one-filter/m-p/1310083#M407351 <HTML><HEAD></HEAD><BODY><P>Sure, try this</P><P></P><P><STRONG>Avg({1&lt;Year = $::Year&gt;} A)</STRONG></P></BODY></HTML> Fri, 14 Jul 2017 11:20:46 GMT https://community.qlik.com/t5/QlikView/Variable-which-is-only-affected-by-one-filter/m-p/1310083#M407351 sunny_talwar 2017-07-14T11:20:46Z Re: Variable which is only affected by one filter https://community.qlik.com/t5/QlikView/Variable-which-is-only-affected-by-one-filter/m-p/1310084#M407352 <HTML><HEAD></HEAD><BODY><P>or this</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Avg({1&lt;Year = p(Year)&gt;} A)</STRONG></P></BODY></HTML> Fri, 14 Jul 2017 11:29:06 GMT https://community.qlik.com/t5/QlikView/Variable-which-is-only-affected-by-one-filter/m-p/1310084#M407352 sunny_talwar 2017-07-14T11:29:06Z