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
