Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
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
Highlighted
Contributor
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

View solution in original post

2 Replies
Highlighted
Master
Master

Re: Excluding values from column

Hi

Can you share some sample data to work upon?

Thanks

Shivesh Singh

Highlighted
Contributor
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

View solution in original post