Discussion Board for collaboration related to Creating Analytics for QlikView.
I have a field : Call_Priority.
It holds the following values
I am trying to make a Straight Table diaplay the percentage of each of these values compared to the total.
The Dimention is Call_Priority.
Each field has a unique ID (fieldname ID)
I tried this expression:
But this is producing 100% for all Call_Priorities. This isnt right.
I think this is because it has Call_Priority as a dimention so the sum(ID) is calculating how many IDs are falling under each value (which will be the same as the count)
I need an expression which will give me the percentage of the total selection that falls within each of the <=7.... etc values
The % values should always add up to 100%.
Any advice is appreciated.
Go to Solution.
try count(ID)/count(total ID)
=count(Call_Priority) / count(TOTAL Call_Priority)
and set the format in number tab to show percentage.
Both work perfectly, unfortunately only one correct answer allowed!
Thank you for your help guys.
Each day i seem to learn just a little more!