How to combine 2 set analysis

[NewToQlik]

Hi all,

Currently, I am using this measure below. Is it possible to combine all of this? I tried using sum() but it did not work.

count(distinct {<[Current score]={"< $(APlusSlider)"},[Current_Grade]= {'A+'}>}[Student_name])

+ count(distinct {<[Current score] = {">= $(ASlider)"},[Current_Grade]= {'B+'}>}[Student_name])

+ count(distinct {<[Current score] = {">= $(ASlider)"},[Current_Grade]= {'B'}>}[Student_name])

Much help is appreciated.

Thank you.

[agigliotti]

what does the content of "ASlider" and "APlusSlider" variables is ?

[NewToQlik]

The variables are the minimum score for each grade, eg 'A+', 'A', and so on.

[NewToQlik]

Currently the measure on top works, but I would like to have it as a shorter expression, since there are many grades in my data.

[mikaelsc · Accepted solution]

read (and keep this close) this :Set Analysis: syntaxes, examples

so something like:

count(distinct

{<[Current score]={"<$(APlusSlider)"},[Current_Grade]= {'A+'}>

+<[Current score] = {">=$(ASlider)"},[Current_Grade]= {'B+'}>

+ <[Current score] = {">=$(ASlider)"},[Current_Grade]= {'B'}>}[Student_name])

(+ remove spaces in your current score modifiers)

[NewToQlik]

Thank you very much! It works now