Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this?
Sum({<[Employee ID] = {"=AvailableHours/BaseHours >= 0.90"}>} AvailableHours))
Did the count work?
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.
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?
Is Demand% a field or expression? If it is an expression who is this calculated? against what dimension?
Demand% is calculated in Variable. This is not a field.
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.
No Sunny. We have only 1 Variable for all the employees.
Demand%=Field1/Field2
Hi
Attaching the sample data where Demand% is calculated using AVailableHours/BaseHours
May be this:
Count(DISTINCT {<[Employee ID] = {"=AvailableHours/BaseHours >= 0.90"}>} [Employee ID]))
How can we write the above expression for AvailableHours
I mean instead of employee id count, Sum the Available Hours