Pre-Calculation for Dimension

[kfir1987]

Hi all,

I would like to show utilization of my machines, the logic for the utilization is:

1. Calculate the total time for each machine.
2. Pick the Top 10.
3. On those 10 ten, show the utilization (I have the formula to utilization no need to help with that)

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).

Thanks for help  

[Or · Accepted solution]

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:

in qlikview i want take top 10 salaries how to ... | Qlik Community