Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

How to use set analysis? Cost per hour consultant

Hi,

I need to calculate the cost per hour for an consultant.

The cost per hour will be: (Total Cost / Total worked hours)

But I also need the cost per client A:

The cost for cliente A: (Total Cost / Total worked hours) * Total worked hours for client A

I have in total 10 clients, but when I try to calculate for 1 client the cost per client is incorrect.

I will aprecciate if someone can help me.

Best regards!

1 Reply
Not applicable

Re: How to use set analysis? Cost per hour consultant

May be a straight table can be used.

Dimension - Client

Expression - (Total Sum(Cost)/ Total sum(Worked Hours))* sum(Worked Hours)

Community Browser