Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Percentage Not Calculating

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

L

1 Solution

Accepted Solutions

Re: Percentage Not Calculating

try count(ID)/count(total ID)


talk is cheap, supply exceeds demand
3 Replies

Re: Percentage Not Calculating

try count(ID)/count(total ID)


talk is cheap, supply exceeds demand
MVP
MVP

Re: Percentage Not Calculating

Try

=count(Call_Priority) / count(TOTAL Call_Priority)

and set the format in number tab to show percentage.

Not applicable

Re: Percentage Not Calculating

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

L

Community Browser