Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
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

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

Hi

Can you share some sample data to work upon?

Thanks

Shivesh Singh

Highlighted
Contributor
Contributor

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