Discussion Board for collaboration related to QlikView App Development.
Dear all, I am trying to create a calculation that divides a row value in a table by the maximum value within that column.
My table looks like this:
Calls is a variable:
COUNT(DISTINCT [Call ID])
Max Calls is a variable:
AGGR(MAX(AGGR(COUNT(DISTINCT [Call ID]),[Created Month])),category)
What I am trying to do is divide each row by the maximum value. I.e. based on above, row 1 would be 761/897.
I cant work out how to calculate this maximum value for the table then use it across all values. Any other way I have tried leads to the max value being the same as the count of calls.
Go to Solution.
Try one of these
AGGR(NODISTINCT MAX(AGGR(COUNT(DISTINCT [Call ID]),[Created Month])),category)
MAX(TOTAL <category> AGGR(COUNT(DISTINCT [Call ID]),[Created Month]))
Excellent - Sunny my hero once again.
I have been struggling with this for ages. I was not familiar with the no distinct command!