Count the number of Employees

[satishkurra]

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

[sunny_talwar · Accepted solution]

May be this?

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

Did the count work?

[satishkurra]

Count worked Sunny. Thanks