topic Filtering Data works slowly in QlikView https://community.qlik.com/t5/QlikView/Filtering-Data-works-slowly/m-p/1235792#M393119 <HTML><HEAD></HEAD><BODY><P>In the dashboard Navigation and other objects are running fine however filtering is working very slow. It is taking almost 40 seconds for any particular filter when i click on any list box where as dashboard loads in 7 seconds.</P></BODY></HTML> Fri, 09 Dec 2016 10:15:52 GMT rsdhavle 2016-12-09T10:15:52Z Filtering Data works slowly https://community.qlik.com/t5/QlikView/Filtering-Data-works-slowly/m-p/1235792#M393119 <HTML><HEAD></HEAD><BODY><P>In the dashboard Navigation and other objects are running fine however filtering is working very slow. It is taking almost 40 seconds for any particular filter when i click on any list box where as dashboard loads in 7 seconds.</P></BODY></HTML> Fri, 09 Dec 2016 10:15:52 GMT https://community.qlik.com/t5/QlikView/Filtering-Data-works-slowly/m-p/1235792#M393119 rsdhavle 2016-12-09T10:15:52Z Re: Filtering Data works slowly https://community.qlik.com/t5/QlikView/Filtering-Data-works-slowly/m-p/1235793#M393120 <HTML><HEAD></HEAD><BODY><P>Try analyzing the document with <A href="https://community.qlik.com/thread/241313">Document Analyzer V3.2 Update</A> to see which parts are impacting performance.</P></BODY></HTML> Fri, 09 Dec 2016 10:19:45 GMT https://community.qlik.com/t5/QlikView/Filtering-Data-works-slowly/m-p/1235793#M393120 Gysbert_Wassenaar 2016-12-09T10:19:45Z Re: Filtering Data works slowly https://community.qlik.com/t5/QlikView/Filtering-Data-works-slowly/m-p/1235794#M393121 <HTML><HEAD></HEAD><BODY><P>We have already setup analyzer V3.1..in that i can see some data elements taking memory..is there any way we can see if any particular expression is causing this or handling data elements will help in our case?</P></BODY></HTML> Fri, 09 Dec 2016 11:42:56 GMT https://community.qlik.com/t5/QlikView/Filtering-Data-works-slowly/m-p/1235794#M393121 rsdhavle 2016-12-09T11:42:56Z Re: Filtering Data works slowly https://community.qlik.com/t5/QlikView/Filtering-Data-works-slowly/m-p/1235795#M393122 <HTML><HEAD></HEAD><BODY><P>Yes. Test the expressions individually to see what each contributes to the calculation cost.</P></BODY></HTML> Fri, 09 Dec 2016 11:56:08 GMT https://community.qlik.com/t5/QlikView/Filtering-Data-works-slowly/m-p/1235795#M393122 Gysbert_Wassenaar 2016-12-09T11:56:08Z Re: Filtering Data works slowly https://community.qlik.com/t5/QlikView/Filtering-Data-works-slowly/m-p/1235796#M393123 <HTML><HEAD></HEAD><BODY><P>Thanks i am getting idea about calculation cost for each expression. Putting any particular expression into variable will help?</P></BODY></HTML> Fri, 09 Dec 2016 12:37:50 GMT https://community.qlik.com/t5/QlikView/Filtering-Data-works-slowly/m-p/1235796#M393123 rsdhavle 2016-12-09T12:37:50Z Re: Filtering Data works slowly https://community.qlik.com/t5/QlikView/Filtering-Data-works-slowly/m-p/1235797#M393124 <HTML><HEAD></HEAD><BODY><P>That depends. It will still need to be calculated. But it may make a difference if it doesn't need to be calculated at the row level, but can be calculated at the document level.</P></BODY></HTML> Fri, 09 Dec 2016 12:47:05 GMT https://community.qlik.com/t5/QlikView/Filtering-Data-works-slowly/m-p/1235797#M393124 Gysbert_Wassenaar 2016-12-09T12:47:05Z