Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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% |
Hi Megha,
Do you want the count of companies whose comulative % is less than 10% ? Am i right?
Regards
KC
hi jyothish,
You are right but the percentage is not fixed ,it can vary when we make any change in slider
try in text box,
count({<[cumulative %]={">=10%"}>}student)
Regards
KC
I think it should not matter , take a benchmark % (eg 20 %). any thing below 20% will be counted.
Regards
KC
Is this regarding QlikView or Qlik Sense?
Qlikview
Megha goyal
ESSEX Lake Group,LLC
Skype:meghagoyal091
Megha.goyal@essexlg.com
IN:+91 9650297106
ok I'll move the tread to the correct area.
Actually its a variable.
COUNT({$< [cumulative %] = {">= $(vValueInSlider)"}>} student)
That should work.
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