Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
satishkurra
Specialist II
Specialist II

Count the number of Employees

Hi

I'm trying to get the number of employees count based on the Demand%

If Demand%=100%, 100% Available, if  Demand%= 90%, 90% Available.

I'm trying to use the text object to display the count of employees who are 100%,90%,80% Available.

I'm getting the Demand% value in a variable as vDemand%

How can i achieve this in a text object in QlikView?

Thanks

Satish

1 Solution

Accepted Solutions
sunny_talwar

May be this?

Sum({<[Employee ID] = {"=AvailableHours/BaseHours >= 0.90"}>} AvailableHours))

Did the count work?

View solution in original post

11 Replies
sunny_talwar

I am afraid you will have to provide more information then this. I don't think we will be able to offer much advice based on what is provided.

satishkurra
Specialist II
Specialist II
Author

Sunny

I'm trying to count the number of employees who Demand% is 100%, 90%,80%....

I'm trying to achieve this in text object.

Demand % is coming from a Variable vDemand%

Is this clear now?

sunny_talwar

Is Demand% a field or expression? If it is an expression who is this calculated? against what dimension?

satishkurra
Specialist II
Specialist II
Author

Demand% is calculated in Variable. This is not a field.

sunny_talwar

So you have multiple variable? one for each employee?

Demand%1

Demand%2?

See those are the kind of things you need to elaborate, as we cannot assume to know what is there in your data model.

satishkurra
Specialist II
Specialist II
Author

No Sunny. We have only 1 Variable for all the employees.

Demand%=Field1/Field2

satishkurra
Specialist II
Specialist II
Author

Hi

Attaching the sample data where Demand% is calculated using AVailableHours/BaseHours

sunny_talwar

May be this:

Count(DISTINCT {<[Employee ID] = {"=AvailableHours/BaseHours >= 0.90"}>} [Employee ID]))

satishkurra
Specialist II
Specialist II
Author

How can we write the above expression for AvailableHours

I mean instead of employee id count, Sum the Available Hours