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

terezagr — Tue, 15 Jul 2014 15:12:03 GMT

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?

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

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