topic Re: Percentage Not Calculating in QlikView

Percentage Not Calculating

Tue, 29 Jan 2013 12:01:59 GMT

Hi Guys,

I have a field : Call_Priority.

It holds the following values

<=7

>7 <=14

>14 <=21

>21

Ongoing

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:

=count(Call)Priority/count(ID)

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.

Thank you

Re: Percentage Not Calculating

Gysbert_Wassenaar — Tue, 29 Jan 2013 12:07:37 GMT

try count(ID)/count(total ID)

Re: Percentage Not Calculating

swuehl — Tue, 29 Jan 2013 12:08:07 GMT

Try

=count(Call_Priority) / count(TOTAL Call_Priority)

and set the format in number tab to show percentage.

Re: Percentage Not Calculating

Tue, 29 Jan 2013 12:13:02 GMT

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!

Regards