topic Count Issue: Counting regardless of Dimension in QlikView

Count Issue: Counting regardless of Dimension

Tue, 31 Mar 2015 03:08:00 GMT

Please see the picture attached above.

My dimension is "Supervisor." And I listed the accidents, first aid, and incidnet types.

My concern is that I would like to find out the percentage of each expression.

For example of utility, supervisor B had 2 utility incidents out of 4, which means his untility % must equal to 50%.

I would like to place each percentages for each expression.

Could you please help me on this issue? I've attached the files.

Thank you.

Anonymous — Tue, 31 Mar 2015 03:23:22 GMT

Hi,

Please see attached.

Change your expresion to

count({<[Incident type]={'Utility'}>}Case#)/count(TOTAL{<[Incident type]={'Utility'}>}Case#)

Regards,

Greeshma

danieloberbilli — Tue, 31 Mar 2015 03:29:32 GMT

Please find attached

Tue, 31 Mar 2015 14:16:16 GMT

Thank you so much!

Tue, 31 Mar 2015 14:16:52 GMT

Thank you so much Daniel.