OR syntax in set analysis

Anonymous — Mon, 15 Dec 2014 08:36:00 GMT

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

Re: OR syntax in set analysis

Gysbert_Wassenaar — Mon, 15 Dec 2014 08:47:40 GMT

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

Re: OR syntax in set analysis

Anonymous — Mon, 15 Dec 2014 08:54:25 GMT

Nice!

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

topic Re: OR syntax in set analysis in QlikView

OR syntax in set analysis

Re: OR syntax in set analysis

Re: OR syntax in set analysis