topic Dimension affected in the excluding filter in QlikView https://community.qlik.com/t5/QlikView/Dimension-affected-in-the-excluding-filter/m-p/615078#M681899 <HTML><HEAD></HEAD><BODY><P>Ciao,</P><P>I need to have a figure fixed with the cummulate, so i put this expresion</P><P></P><P><SPAN style="font-size: 8pt;">sum&nbsp; ({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Weeks</SPAN><SPAN style="font-size: 8pt;">=,</SPAN><SPAN style="color: #800000; font-size: 8pt;">Month</SPAN><SPAN style="font-size: 8pt;">=,</SPAN><SPAN style="color: #800000; font-size: 8pt;">Quarter</SPAN><SPAN style="font-size: 8pt;">=,</SPAN><SPAN style="color: #800000; font-size: 8pt;">Year</SPAN><SPAN style="font-size: 8pt;">=,</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Year Cruise]</SPAN><SPAN style="font-size: 8pt;">=,</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Quarter Cruise]</SPAN><SPAN style="font-size: 8pt;">=,</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Month Cruise]</SPAN><SPAN style="font-size: 8pt;">=&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">NUM_PAX)</SPAN></P><P>The thing is that, when i filter for example by región, this cummulate is not changing ( is taking all the regions), and i need the cummulate with the selections that i do, but the timing selections, it is this posible?</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 07 Mar 2014 16:23:13 GMT 2014-03-07T16:23:13Z Dimension affected in the excluding filter https://community.qlik.com/t5/QlikView/Dimension-affected-in-the-excluding-filter/m-p/615078#M681899 <HTML><HEAD></HEAD><BODY><P>Ciao,</P><P>I need to have a figure fixed with the cummulate, so i put this expresion</P><P></P><P><SPAN style="font-size: 8pt;">sum&nbsp; ({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Weeks</SPAN><SPAN style="font-size: 8pt;">=,</SPAN><SPAN style="color: #800000; font-size: 8pt;">Month</SPAN><SPAN style="font-size: 8pt;">=,</SPAN><SPAN style="color: #800000; font-size: 8pt;">Quarter</SPAN><SPAN style="font-size: 8pt;">=,</SPAN><SPAN style="color: #800000; font-size: 8pt;">Year</SPAN><SPAN style="font-size: 8pt;">=,</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Year Cruise]</SPAN><SPAN style="font-size: 8pt;">=,</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Quarter Cruise]</SPAN><SPAN style="font-size: 8pt;">=,</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Month Cruise]</SPAN><SPAN style="font-size: 8pt;">=&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">NUM_PAX)</SPAN></P><P>The thing is that, when i filter for example by región, this cummulate is not changing ( is taking all the regions), and i need the cummulate with the selections that i do, but the timing selections, it is this posible?</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 07 Mar 2014 16:23:13 GMT https://community.qlik.com/t5/QlikView/Dimension-affected-in-the-excluding-filter/m-p/615078#M681899 2014-03-07T16:23:13Z Re: Dimension affected in the excluding filter https://community.qlik.com/t5/QlikView/Dimension-affected-in-the-excluding-filter/m-p/615079#M681900 <HTML><HEAD></HEAD><BODY><P>Hey Belen,</P><P>Your expression should be working properly. Can you attach your sample file for debugging.</P><P>Thanks</P><P>AJ</P></BODY></HTML> Fri, 07 Mar 2014 19:45:52 GMT https://community.qlik.com/t5/QlikView/Dimension-affected-in-the-excluding-filter/m-p/615079#M681900 2014-03-07T19:45:52Z