Filter data on given input condition

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Name	School	city	Flag_class12	Flag_class10	Score
ram	ABC	delhi	1	0	78
mohan	ABC	delhi	0	1	62
ravi	DEF	Mumbai	0	0	56
ramesh	GHI	Mumabi	1	0	48

large data only sample is shown here .

Raw data is as shown above: Flag_class12 :if student is in class 12 then 1 otherwise 0, similarly for Flag_class10.

we need to create a view with following options in output.

school
Drop down filter

CITY
Drop down filter

these are used to filter data on basis of city and school, now I need to invite some student to a event , user will enter then number,
and how many 12th students and how many 1th student must come, based on their scores

Total Students
user enter value

Class 12th
How many 12 th class student in percentage entered by used

Class 10 th
How many 10 th class student in percentage entered by use

Rest student based on scores:

output required :

Student Name	Student class

Ex: suppose user select total students as 100, and 12th class as 20% and 10 th class as 40% then

in final table we require 20 12th student , then 40th student and rest 40 other students.

how can we create the last table with student name and class ??

topic Filter data on given input condition in QlikView

Filter data on given input condition