topic how create field / table not affected by filter ? in QlikView https://community.qlik.com/t5/QlikView/how-create-field-table-not-affected-by-filter/m-p/332061#M122344 <HTML><HEAD></HEAD><BODY><P><SPAN id="result_box" lang="en"><SPAN class="hps">Hello everyone</SPAN> <SPAN class="hps">and sorry</SPAN> <SPAN class="hps">for my</SPAN> <SPAN class="hps">bad English</SPAN><BR /><SPAN class="hps">I have a</SPAN> <SPAN class="hps">form where</SPAN> <SPAN class="hps">I view</SPAN> <SPAN class="hps">data for a customer</SPAN><SPAN>,</SPAN> <SPAN class="hps">and I would</SPAN> <SPAN class="hps">even show</SPAN> <SPAN class="hps">a field</SPAN><SPAN>,</SPAN> <SPAN class="hps">table or</SPAN> <SPAN class="hps">chart that</SPAN> <SPAN class="hps">I</SPAN> <SPAN class="hps">compare the</SPAN> <SPAN class="hps">data of</SPAN> <SPAN class="hps">this customer</SPAN> <SPAN class="hps">with respect</SPAN> <SPAN class="hps">to the total</SPAN> <SPAN class="hps">of its zone</SPAN><SPAN>, district</SPAN><SPAN>,</SPAN> <SPAN class="hps">state, etc.</SPAN><SPAN>.</SPAN> <SPAN class="hps">etc.</SPAN><SPAN>.</SPAN> <SPAN class="hps">but having</SPAN> <SPAN class="hps">set</SPAN> <SPAN class="hps">the filter to</SPAN> <SPAN class="hps">the customer as</SPAN> <SPAN class="hps">I do</SPAN><SPAN>?</SPAN> <SPAN class="hps">thanks</SPAN> <SPAN class="hps">in advance</SPAN></SPAN></P></BODY></HTML> Thu, 01 Mar 2012 16:58:28 GMT 2012-03-01T16:58:28Z how create field / table not affected by filter ? https://community.qlik.com/t5/QlikView/how-create-field-table-not-affected-by-filter/m-p/332061#M122344 <HTML><HEAD></HEAD><BODY><P><SPAN id="result_box" lang="en"><SPAN class="hps">Hello everyone</SPAN> <SPAN class="hps">and sorry</SPAN> <SPAN class="hps">for my</SPAN> <SPAN class="hps">bad English</SPAN><BR /><SPAN class="hps">I have a</SPAN> <SPAN class="hps">form where</SPAN> <SPAN class="hps">I view</SPAN> <SPAN class="hps">data for a customer</SPAN><SPAN>,</SPAN> <SPAN class="hps">and I would</SPAN> <SPAN class="hps">even show</SPAN> <SPAN class="hps">a field</SPAN><SPAN>,</SPAN> <SPAN class="hps">table or</SPAN> <SPAN class="hps">chart that</SPAN> <SPAN class="hps">I</SPAN> <SPAN class="hps">compare the</SPAN> <SPAN class="hps">data of</SPAN> <SPAN class="hps">this customer</SPAN> <SPAN class="hps">with respect</SPAN> <SPAN class="hps">to the total</SPAN> <SPAN class="hps">of its zone</SPAN><SPAN>, district</SPAN><SPAN>,</SPAN> <SPAN class="hps">state, etc.</SPAN><SPAN>.</SPAN> <SPAN class="hps">etc.</SPAN><SPAN>.</SPAN> <SPAN class="hps">but having</SPAN> <SPAN class="hps">set</SPAN> <SPAN class="hps">the filter to</SPAN> <SPAN class="hps">the customer as</SPAN> <SPAN class="hps">I do</SPAN><SPAN>?</SPAN> <SPAN class="hps">thanks</SPAN> <SPAN class="hps">in advance</SPAN></SPAN></P></BODY></HTML> Thu, 01 Mar 2012 16:58:28 GMT https://community.qlik.com/t5/QlikView/how-create-field-table-not-affected-by-filter/m-p/332061#M122344 2012-03-01T16:58:28Z how create field / table not affected by filter ? https://community.qlik.com/t5/QlikView/how-create-field-table-not-affected-by-filter/m-p/332062#M122345 <HTML><HEAD></HEAD><BODY><P> you need to use set analysis </P><P></P><P>let say for zone</P><P></P><P>sum({&lt;Customer=,Zone=Zone&gt;}Sales)</P></BODY></HTML> Thu, 01 Mar 2012 17:17:59 GMT https://community.qlik.com/t5/QlikView/how-create-field-table-not-affected-by-filter/m-p/332062#M122345 lironbaram 2012-03-01T17:17:59Z