Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Select multiple values based on current selection - use both in set analysis

Hi all,

in my scenario a student can take different Modules. For an example I have these Modules:

AH10

AH11

AH12

BL20

BL21

BL30

BL32

When a user select from a list box AH10, I would like to create a set analysis where I would count the number of students taking this module compared with all AH1 modules.

So, what I would like to eventually get should look like:

Count({Grade,Module={"$(=vModuleCode)"}}Student) / Count ({Grade,Module={"$(=vModuleCodeALL)"}}Student)

As you can see I have already created a variable for the selected module vModuleCode and I would like to create a similar variable where I would like to store all values for Modules from the same 'category'. So if user selects a module AH10, then in the vModuleCodeALL variable should be assigned values AH10,AH11,AH12.

Any suggestions?

0 Replies