topic Pre-Calculation for Dimension in QlikView https://community.qlik.com/t5/QlikView/Pre-Calculation-for-Dimension/m-p/86157#M509385 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I would like to show utilization of my machines, the logic for the utilization is:</P><OL><LI><SPAN style="font-size: 10pt;">Calculate the total time for each machine.</SPAN></LI><LI><SPAN style="font-size: 10pt;">Pick the Top 10.</SPAN></LI><LI><SPAN style="font-size: 10pt;">On those 10 ten, show the </SPAN><SPAN style="font-size: 13.3333px;">utilization (I have the formula to utilization no need to help with that) </SPAN></LI></OL><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">So I have the utilization measure, but I don`t know how to do pre-calculation to get the top ten machine (total time working time).</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Thanks for help&nbsp;&nbsp; </SPAN></P></BODY></HTML> Sun, 02 Sep 2018 12:41:52 GMT kfir1987 2018-09-02T12:41:52Z Pre-Calculation for Dimension https://community.qlik.com/t5/QlikView/Pre-Calculation-for-Dimension/m-p/86157#M509385 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I would like to show utilization of my machines, the logic for the utilization is:</P><OL><LI><SPAN style="font-size: 10pt;">Calculate the total time for each machine.</SPAN></LI><LI><SPAN style="font-size: 10pt;">Pick the Top 10.</SPAN></LI><LI><SPAN style="font-size: 10pt;">On those 10 ten, show the </SPAN><SPAN style="font-size: 13.3333px;">utilization (I have the formula to utilization no need to help with that) </SPAN></LI></OL><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">So I have the utilization measure, but I don`t know how to do pre-calculation to get the top ten machine (total time working time).</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Thanks for help&nbsp;&nbsp; </SPAN></P></BODY></HTML> Sun, 02 Sep 2018 12:41:52 GMT https://community.qlik.com/t5/QlikView/Pre-Calculation-for-Dimension/m-p/86157#M509385 kfir1987 2018-09-02T12:41:52Z Re: Pre-Calculation for https://community.qlik.com/t5/QlikView/Pre-Calculation-for-Dimension/m-p/86158#M509386 <HTML><HEAD></HEAD><BODY><P>You can adapt the solutions suggested in the below thread - it's essentially the same question, and I'd rather link it so you can pick the approach that works best for you:</P><P><A href="https://community.qlikview.com/thread/113293" title="https://community.qlikview.com/thread/113293">in qlikview i want take top 10 salaries how to ... | Qlik Community</A></P></BODY></HTML> Sun, 02 Sep 2018 13:17:08 GMT https://community.qlik.com/t5/QlikView/Pre-Calculation-for-Dimension/m-p/86158#M509386 Or 2018-09-02T13:17:08Z