OR syntax in set analysis

[Anonymous]

Hello Qlikview colleagues

I'm simply trying to get this set analysis syntax to Work.

=sum( {1< Type = {'Afgang'},
KontorNy = {'Kontoret for Permanent Ophold'} >+<  Team = {'_US-BS-TBteam1', '_US-BS-TBteam2'}
>}Antal)

It is suppose to be independent of selections on the sheet hence the '1'.

I'm trying to sum the cases where either:

• KontorNy = {'Kontoret for Permanent Ophold'}
• OR
• Team = {'_US-BS-TBteam1', '_US-BS-TBteam2'}
  

I use the syntax '>+<' for the OR statement, which seems to Work.

The problem is that when I use this '>+<'  - then it does not recognize other selections in fields in the set analysis,

For instance Type = {'Afgang'}, which I have included in the example above.

Are there any suggestions to what could be wrong, or how I alternatively solve the syntax problem of an "OR STATEMENT".

Best regards

Michael Wad

[Gysbert_Wassenaar · Accepted solution]

sum( {1< Type = {'Afgang'}, KontorNy = {'Kontoret for Permanent Ophold'} >+< Type = {'Afgang'}, Team = {'_US-BS-TBteam1', '_US-BS-TBteam2'}
>}Antal)

[Anonymous]

Nice!

Did not think of writing it twice like that - Tanks!