Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

pthomas3253
New 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!

Tags (1)
2 Replies
zebhashmi
Valued Contributor

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

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]))

justinphamvn
Contributor II

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

Hi pthomas3253,

Better if you share samples data and result for this measure

Regards,

Justin.

Community Browser