This content has been marked as final. Show 6 replies
Please consider the following example:
I will be loading the above table directly into Qlik. What I want is to first have an average of Value so that the following table is obtained:
from this now I have to find the name of the category having the highest value. So, from table1 I have to obtain Category B as the answer.
How to perform the above using Set Analysis or/and Back-end scripting?