Set analysis help

[QlikBeginner1]

Hello

I have created a number of flags in the back end, however I am trying to create an validation report based off these fields. 

I have created three flags BBNIFLAG01,02,03. This is what brings through the correct data for the report I am trying to build. I have created two validation flags, and in the main report I have used :

Sum({$<BBNIFLAG01 = {'1'}, BBNIFLAG02 = {'1'},BBNIFLAG03 = {'1'}, BBNIVAL02 = {'1'} , BBNIVAL02 = {'1'} >}GrossWrittenPremium)

I am trying to use a syntax similar to 

Sum({$<BBNIFLAG01 = {'1'} and BBNIFLAG02 = {'1'} and BBNIFLAG03 = {'1'} and  BBNIVAL02 = {'0'}  OR BBNIVAL02 = {'0'} >}GrossWrittenPremium), when i try to use 

Sum({$<BBNIFLAG01 = {'1'}, BBNIFLAG02 = {'1'},BBNIFLAG03 = {'1'}, BBNIVAL02 = {'0'} , BBNIVAL02 = {'0'} >}GrossWrittenPremium), 

This gives me NULL results, how can i bring into the validation report where FLAG01-02-03 = '1' and IF VAL01 or VAL02 = '0'

[GaryGiles · Accepted solution]

Try this: 

Sum({$<BBNIFLAG01 = {'1'}, BBNIFLAG02 = {'1'},BBNIFLAG03 = {'1'}, BBNIVAL01 = {'0'} >+

             <BBNIFLAG01 = {'1'}, BBNIFLAG02 = {'1'},BBNIFLAG03 = {'1'}, BBNIVAL02 = {'0'} >}GrossWrittenPremium)

[QlikBeginner1]

Fantastic Gary Giles!! works perfectly 🙂