Excluding values from column

[kkemmler]

Dear community,

I want to visualize employee workload in a line chart and have the worked hours on external and internal project.

Here is my data:

[column]

extern

extern

intern

(...)

Workload:
([column]-intern) / column = worked hours on extern in percentage

Help is greatly appreciated, thank you very much

[shiveshsingh]

Hi

Can you share some sample data to work upon?

Thanks

Shivesh Singh

[kkemmler · Accepted solution]

Hello,

thank you very much for your response, after talking to a data analyst who happens to work with Qlik as well, he gave me this formula, which worked out in the end:

sum({1<[Status]={external} >} hours)/sum(hours)

"external"=the value I want to pick from the column "Status"

"hours"=the worked hours to and here, I guess he creates a connection

Best regards