Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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
sum( {1< Type = {'Afgang'}, KontorNy = {'Kontoret for Permanent Ophold'} >+< Type = {'Afgang'}, Team = {'_US-BS-TBteam1', '_US-BS-TBteam2'}
>}Antal)
sum( {1< Type = {'Afgang'}, KontorNy = {'Kontoret for Permanent Ophold'} >+< Type = {'Afgang'}, Team = {'_US-BS-TBteam1', '_US-BS-TBteam2'}
>}Antal)
Nice!
Did not think of writing it twice like that - Tanks!