topic Re: Calculating percentage in QlikView

Calculating percentage

deepakqlikview_123 — Tue, 29 Apr 2014 08:21:25 GMT

Hi All,

I want to calculate percentage for employee absenteeism.

Can you please tell me what would be the different ways for achieving the same.

Thanks

MK_QSL — Tue, 29 Apr 2014 08:26:37 GMT

Can you please elaborate little more on your requirements?

deepakqlikview_123 — Tue, 29 Apr 2014 08:29:55 GMT

There is employee absentee count for number of employee who are absent on particular day.

I need to show percentage count of absent employee for the same.

Thanks,

Deepak

MK_QSL — Tue, 29 Apr 2014 08:32:16 GMT

COUNT({<Flag = {'Absent'}>}Employee)/COUNT(Total {<Flag = {'Absent'}>}Employee)

COUNT({<Flag = {'Absent'}>}Employee)/COUNT(Total Employee)

is this what you are looking for?

deepakqlikview_123 — Tue, 29 Apr 2014 08:34:33 GMT

Thanks manish

but how to format number in this case.

MK_QSL — Tue, 29 Apr 2014 08:45:08 GMT

To format in %

In tables and charts you can use Number tab

In text object

NUM(YourExpression, '#,##0.00%')

NUM(YourExpression, '#,##0%')