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: 
aisolomatin
Contributor III
Contributor III

Slider&Custom condition

Hi!

I'm stucked with issue and hope somebody helps me.

What we get:

1. Company with Branches, Divisions and Subdivisions;

2. Data about staff: number of Regular staff, number of Vacancies;

3. Time period: 2 months.

What we need to know:

1. How many Subdivisions/Divisions/Branches achived the plan for %_staffing (98%).

Formula for %_staffing = 1-Vacancies/Regular staff.

We got Staff_in_Subdivision and Vacancies_in_Subdivision sliders for flexibile subdivisions filtration.

qlik.png

For Date="01.01.2016"

If we set up Staff slider to 120, and Vacancies slider to 2, then we should get next result.

excel_2.png

We excluded all Subdivisions, that have staff<120 and Vac<2.

And specific condition: if Division have only "n_a" Subdivision that fit to our condition (Staff>=120 and Vac>=2), then we don't need to count it (Division 22).

0 Replies