topic Re: Error filtering data in simple table in QlikView https://community.qlik.com/t5/QlikView/Error-filtering-data-in-simple-table/m-p/107154#M1247855 <HTML><HEAD></HEAD><BODY><P>Hi Juan,</P><P></P><P>I have looked at your data. Column F is being aggregated as Sum(F).</P><P>The search happening on your Total column for &gt;80 selects its respective dimensions.</P><P>i.e. for Sum(F) &gt; 80 in the straight table selects B -1,2 and C - F1, F2, F4.</P><P></P><P><STRONG>Selections are always made on Dimensions, not on expressions.</STRONG></P><P></P><P>I have added a Current Selections Object which shows you the selections made.</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/213139_pastedImage_2.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P></P><P></P><P>Alternatively, if your search has to be user based then create a list box or Multi box for column F.</P></BODY></HTML> Mon, 10 Sep 2018 13:59:44 GMT vamsee 2018-09-10T13:59:44Z Error filtering data in simple table https://community.qlik.com/t5/QlikView/Error-filtering-data-in-simple-table/m-p/107151#M1247852 <HTML><HEAD></HEAD><BODY><P>How are you,</P><P>I have a problem filtering records in a simple table, when I filter a field I get more records. see images.</P><P></P><P></P><P>Table:</P><P></P><P><IMG alt="Foto1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/213009_Foto1.png" style="height: auto;" /></P><P>Tabla Aggregate</P><P></P><P><IMG alt="Foto2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/213010_Foto2.png" style="height: auto;" /></P><P>Filter &gt;80</P><P><IMG alt="Foto4.png" class="image-5 jive-image" src="https://community.qlik.com/legacyfs/online/213016_Foto4.png" style="height: auto;" /></P><P>Values less than 80 are displayed</P><P><IMG alt="Foto6.png" class="image-4 jive-image" src="https://community.qlik.com/legacyfs/online/213015_Foto6.png" style="height: auto;" /></P><P>Thanks</P><P>Juan Monasí</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Error-filtering-data-in-simple-table/m-p/107151#M1247852 Anonymous 2026-01-26T18:19:17Z Re: Error filtering data in simple table https://community.qlik.com/t5/QlikView/Error-filtering-data-in-simple-table/m-p/107152#M1247853 <HTML><HEAD></HEAD><BODY><P>whats your formula for total and what are your dimensions?</P><P>Can you provide a sample app?</P></BODY></HTML> Fri, 07 Sep 2018 17:26:29 GMT https://community.qlik.com/t5/QlikView/Error-filtering-data-in-simple-table/m-p/107152#M1247853 vamsee 2018-09-07T17:26:29Z Re: Error filtering data in simple table https://community.qlik.com/t5/QlikView/Error-filtering-data-in-simple-table/m-p/107153#M1247854 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I attach the document</P></BODY></HTML> Fri, 07 Sep 2018 17:33:36 GMT https://community.qlik.com/t5/QlikView/Error-filtering-data-in-simple-table/m-p/107153#M1247854 Anonymous 2018-09-07T17:33:36Z Re: Error filtering data in simple table https://community.qlik.com/t5/QlikView/Error-filtering-data-in-simple-table/m-p/107154#M1247855 <HTML><HEAD></HEAD><BODY><P>Hi Juan,</P><P></P><P>I have looked at your data. Column F is being aggregated as Sum(F).</P><P>The search happening on your Total column for &gt;80 selects its respective dimensions.</P><P>i.e. for Sum(F) &gt; 80 in the straight table selects B -1,2 and C - F1, F2, F4.</P><P></P><P><STRONG>Selections are always made on Dimensions, not on expressions.</STRONG></P><P></P><P>I have added a Current Selections Object which shows you the selections made.</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/213139_pastedImage_2.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P></P><P></P><P>Alternatively, if your search has to be user based then create a list box or Multi box for column F.</P></BODY></HTML> Mon, 10 Sep 2018 13:59:44 GMT https://community.qlik.com/t5/QlikView/Error-filtering-data-in-simple-table/m-p/107154#M1247855 vamsee 2018-09-10T13:59:44Z