This content has been marked as final. Show 4 replies
I am new to qlickview and have a simple request that seems to be more complicated than I would have thought. I need to display the top 10 customers by week based on a metric of SUM(METRIC TONES)
If I have The customer and the week in the dimensions and the follwoing formula in the expressions I get the correct ranking:
The issue is I only want to see the top 10 customers based on that ranking. I have tried a few different versions of what I thought would be needed as a calculated dimension, but all my formulas just output //error calculateing formula.
Not sure how to go about this, any direction would be wonderful.