Set analys

[Elin]

Hello!!

I need help excluding the Team_Kod values, instead of having them with me as now

Sum ({$<Ärendetyp={EKO1}, Team_Kod={"916-ÅR","928-ÅR","930-ÅR","940-ÅR","950-ÅR","960 ÅR"}>}Antal_Ärenden_Inkomna_R12

[JuanGerardo]

Hi @Elin, to exclude instead of select, you can use:

Sum ({$<Ärendetyp={EKO1}, Team_Kod-={"916-ÅR","928-ÅR","930-ÅR","940-ÅR","950-ÅR","960 ÅR"}>}Antal_Ärenden_Inkomna_R12

JG

[Elin]

Hello again!!

It works fine, but I have missing values in Team_Kod that are not included in this code, how do I get them? 

/Elin

[JuanGerardo]

Just add them to the list, separated by commas.

JG

[Elin]

Hello again ! I

have missing values in the dataset that disappear with this code, but I do not want to exclude them

For example, in this set analys, I get them Sum ({$<Ärendetyp={EKO1}>}Antal_Ärenden_Inkomna_R12)

But in this one they disappear even though I want missing values

Sum ({$<Ärendetyp={EKO1},Team_Kod-={"916-ÅR","928-ÅR","930-ÅR","940-ÅR","950-ÅR","960-ÅR"}>}Antal_Ärenden_Inkomna_R12)

[JuanGerardo]

With the -= option you exclude those values from your selections, and with += you include values. I though you wanted to exclude those values. Change -= to += and you will be including instead of excluding.

JG