topic ignore selection in the given set expression in QlikView https://community.qlik.com/t5/QlikView/ignore-selection-in-the-given-set-expression/m-p/1165561#M379510 <HTML><HEAD></HEAD><BODY><P>I am using the set expression to find out "Revenue" at "Latest Year":</P><P>=sum({1&lt;Year={'$(=(max(num#(<STRONG style=": ; color: #ff0000;">Year</STRONG>))))'}&gt;}Revenue)</P><P></P><P>Now, I have a <SPAN style="text-decoration: underline;">list box</SPAN> with a field <STRONG style="text-decoration: underline;"><SPAN style="color: #ff0000; text-decoration: underline;">Year</SPAN></STRONG>, which is used in above expression too. I want that even if I select any value in that list box (that contains Year), the above expression must not change.</P><P></P><P>Can you please help?</P></BODY></HTML> Mon, 04 Jul 2016 07:44:39 GMT 2016-07-04T07:44:39Z ignore selection in the given set expression https://community.qlik.com/t5/QlikView/ignore-selection-in-the-given-set-expression/m-p/1165561#M379510 <HTML><HEAD></HEAD><BODY><P>I am using the set expression to find out "Revenue" at "Latest Year":</P><P>=sum({1&lt;Year={'$(=(max(num#(<STRONG style=": ; color: #ff0000;">Year</STRONG>))))'}&gt;}Revenue)</P><P></P><P>Now, I have a <SPAN style="text-decoration: underline;">list box</SPAN> with a field <STRONG style="text-decoration: underline;"><SPAN style="color: #ff0000; text-decoration: underline;">Year</SPAN></STRONG>, which is used in above expression too. I want that even if I select any value in that list box (that contains Year), the above expression must not change.</P><P></P><P>Can you please help?</P></BODY></HTML> Mon, 04 Jul 2016 07:44:39 GMT https://community.qlik.com/t5/QlikView/ignore-selection-in-the-given-set-expression/m-p/1165561#M379510 2016-07-04T07:44:39Z Re: ignore selection in the given set expression https://community.qlik.com/t5/QlikView/ignore-selection-in-the-given-set-expression/m-p/1165562#M379511 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=sum({1&lt;Year={'$(=(max({1}num#(</SPAN><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #ff0000;">Year</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">))))'}&gt;}Revenue)</SPAN></P></BODY></HTML> Mon, 04 Jul 2016 07:46:30 GMT https://community.qlik.com/t5/QlikView/ignore-selection-in-the-given-set-expression/m-p/1165562#M379511 MK_QSL 2016-07-04T07:46:30Z