Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Count if [Number of layer] = [Number of layer]+1

I've been trying to figure out how to get this ratio formula to work for me and I'm struggling with getting the correct ratios. Basically I have a [Number of Layers] column ranging from 1-10 and then each person falls on one of those layers. I also have managers on each of those layers as well. I need to find the ratio of managers to who reports to them. I am trying to: Look at the [number of layers] that are equa to [Number of layers]+1 and count the [Employee_ID] on that layer then divide by the managers on [Number of layers]. Any help is appreciated!

2 Replies

Can you share some data! by given information, i would say try this

Count(if([Number of layer]=fieldvalue([Number of layer]+1,[Number of layer]))

Creator II
Creator II

Hi pthomas3253,

Better if you share samples data and result for this measure