Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
michaelwad
New Contributor III

OR syntax in set analysis

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

Tags (2)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: OR syntax in set analysis

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


talk is cheap, supply exceeds demand
2 Replies
MVP & Luminary
MVP & Luminary

Re: OR syntax in set analysis

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


talk is cheap, supply exceeds demand
michaelwad
New Contributor III

Re: OR syntax in set analysis

Nice!

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