Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
kkemmler
New Contributor

Excluding values from column

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

 

1 Solution

Accepted Solutions
kkemmler
New Contributor

Re: Excluding values from column

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

2 Replies
shiveshsingh
Honored Contributor

Re: Excluding values from column

Hi

Can you share some sample data to work upon?

Thanks

Shivesh Singh

kkemmler
New Contributor

Re: Excluding values from column

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