topic Re: How to limit expression? in QlikView https://community.qlik.com/t5/QlikView/How-to-limit-expression/m-p/61921#M10343 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P> It´s slow when you click on each plus button to expand a month ? </P></BODY></HTML> Tue, 06 Mar 2018 20:26:10 GMT pablolabbe 2018-03-06T20:26:10Z How to limit expression? https://community.qlik.com/t5/QlikView/How-to-limit-expression/m-p/61920#M10342 <HTML><HEAD></HEAD><BODY><P>I have a Pivot table that I created to display Ledger numbers when a Month field is expanded.&nbsp; It then shows each ledger rolling forecast value. If nothing is expanded, it shows the total forecast value</P><P></P><P>My issue is that this pivot table is slow since it has to do the calculations on the fly. How can I set it up so it preloads everything, but the values only show if one Month field is selected? Could I use GetPossibleCount or GetSelectedCount?</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/195506_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Tue, 06 Mar 2018 20:22:08 GMT https://community.qlik.com/t5/QlikView/How-to-limit-expression/m-p/61920#M10342 Anonymous 2018-03-06T20:22:08Z Re: How to limit expression? https://community.qlik.com/t5/QlikView/How-to-limit-expression/m-p/61921#M10343 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P> It´s slow when you click on each plus button to expand a month ? </P></BODY></HTML> Tue, 06 Mar 2018 20:26:10 GMT https://community.qlik.com/t5/QlikView/How-to-limit-expression/m-p/61921#M10343 pablolabbe 2018-03-06T20:26:10Z Re: How to limit expression? https://community.qlik.com/t5/QlikView/How-to-limit-expression/m-p/61922#M10344 <HTML><HEAD></HEAD><BODY><P>Correct, there are quit a few ledger numbers and then it has to pull each forecast value tied to it. I'm trying to make it quicker.</P></BODY></HTML> Tue, 06 Mar 2018 20:28:26 GMT https://community.qlik.com/t5/QlikView/How-to-limit-expression/m-p/61922#M10344 Anonymous 2018-03-06T20:28:26Z Re: How to limit expression? https://community.qlik.com/t5/QlikView/How-to-limit-expression/m-p/61923#M10345 <HTML><HEAD></HEAD><BODY><P>Not sure but you may think of using calculation condition to show the chart only when needed filters are selected using getselectedcount, you may show customized message as well to drive user to make needed selections</P></BODY></HTML> Tue, 06 Mar 2018 20:45:42 GMT https://community.qlik.com/t5/QlikView/How-to-limit-expression/m-p/61923#M10345 Digvijay_Singh 2018-03-06T20:45:42Z