topic Re: Performance Set vs Flag in QlikView https://community.qlik.com/t5/QlikView/Performance-Set-vs-Flag/m-p/948310#M326464 <HTML><HEAD></HEAD><BODY><P>Further reading: <A href="https://community.qlik.com/qlik-blogpost/3808">Performance of Conditional Aggregations</A></P></BODY></HTML> Fri, 09 Oct 2015 16:59:11 GMT Clever_Anjos 2015-10-09T16:59:11Z Performance Set vs Flag https://community.qlik.com/t5/QlikView/Performance-Set-vs-Flag/m-p/948307#M326461 <HTML><HEAD></HEAD><BODY><P>We are discussion how to best solve calculations comparing (Shoes_Flag in Fact table)</P><P></P><P>Sum(Shoes_Flag * Sales)</P><P>Sum({&lt;Shoes_Flag={1}&gt;} Sales)</P><P></P><P>when you have 30 M rows and 100 users regarding memory and response time?</P><P></P><P>Will Section Access affect memory and response time?</P></BODY></HTML> Fri, 09 Oct 2015 14:42:03 GMT https://community.qlik.com/t5/QlikView/Performance-Set-vs-Flag/m-p/948307#M326461 2015-10-09T14:42:03Z Re: Performance Set vs Flag https://community.qlik.com/t5/QlikView/Performance-Set-vs-Flag/m-p/948308#M326462 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Sum({&lt;Shoes_Flag={1}&gt;} Sales) should perform better because the selection is made before the calculation.</SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">For example, if 30% of records are Shoes_Flag=1, only 30% are accumulated<BR /></SPAN></P></BODY></HTML> Fri, 09 Oct 2015 16:46:26 GMT https://community.qlik.com/t5/QlikView/Performance-Set-vs-Flag/m-p/948308#M326462 Clever_Anjos 2015-10-09T16:46:26Z Re: Performance Set vs Flag https://community.qlik.com/t5/QlikView/Performance-Set-vs-Flag/m-p/948309#M326463 <HTML><HEAD></HEAD><BODY><P>There are multiple questions in your post, these posts are about flag vs. set analysis performance:</P><P><A href="https://community.qlik.com/thread/121140">Optimize UI Performance with Flags and Set Analysis</A></P><P><A href="https://community.qlik.com/qlik-blogpost/3808">Performance of Conditional Aggregations</A></P></BODY></HTML> Fri, 09 Oct 2015 16:52:29 GMT https://community.qlik.com/t5/QlikView/Performance-Set-vs-Flag/m-p/948309#M326463 swuehl 2015-10-09T16:52:29Z Re: Performance Set vs Flag https://community.qlik.com/t5/QlikView/Performance-Set-vs-Flag/m-p/948310#M326464 <HTML><HEAD></HEAD><BODY><P>Further reading: <A href="https://community.qlik.com/qlik-blogpost/3808">Performance of Conditional Aggregations</A></P></BODY></HTML> Fri, 09 Oct 2015 16:59:11 GMT https://community.qlik.com/t5/QlikView/Performance-Set-vs-Flag/m-p/948310#M326464 Clever_Anjos 2015-10-09T16:59:11Z