Discussion Board for collaboration related to QlikView App Development.
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) .
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