how to count student lying below a range?

[Anonymous]

Hi All,

I need an urgent help.

let say i have a slider and i want to see students lying below that selected value on the slider.Suppose i select 10% on the slider,then according to that only 3 companies are lying below that,so my question is I need this count(i.e 3) in a text box.

Anyone knows how to calculate the number of companies below the selected value on slider(it can vary and depend on user ,he/she may select 10 or 20) .

student	rank	marks	cumulative %
abc	1	756	5%
xyz	2	657	7%
def	3	454	9%
ghi	4	354	11%
jkl	5	231	12%

[jyothish8807]

Hi Megha,

Do you want the count of companies whose comulative % is less than 10% ? Am i right?

Regards

KC

[Anonymous]

hi jyothish,

You are right but the percentage is not fixed ,it can vary when we make any change in slider

[jyothish8807]

try in text box,

count({<[cumulative %]={">=10%"}>}student)

Regards

KC

[jyothish8807]

I think it should not matter , take a benchmark % (eg 20 %). any thing below 20% will be counted.

Regards

KC

[Josh_Good]

Is this regarding QlikView or Qlik Sense?

[Anonymous]

Qlikview

Megha goyal

ESSEX Lake Group,LLC

Skype:meghagoyal091

Megha.goyal@essexlg.com

IN:+91 9650297106

[Josh_Good]

ok I'll move the tread to the correct area.

[#9]

Actually its a variable.

COUNT({$< [cumulative %] = {">= $(vValueInSlider)"}>} student)

That should work.

[Anonymous]

Cumulative % is calculated on the basis of marks(i.e relative value of marks so as to compare it with the slider value) and it is in pivot table.How I can use this cumulative % result to count the no. Of students in a texbox below the slider range .Example ,only top 3 students contribute to 10 % of the total marks.so my output will be 3 in a separate text box below that pivot table