Set analysis help

QlikBeginner1 — Tue, 21 Dec 2021 20:40:03 GMT

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'

Re: Set analysis help

GaryGiles — Mon, 14 Dec 2020 13:01:57 GMT

Try this:

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

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

Re: Set analysis help

QlikBeginner1 — Mon, 14 Dec 2020 13:19:23 GMT

Fantastic Gary Giles!! works perfectly 🙂

topic Re: Set analysis help in App Development

Set analysis help

Re: Set analysis help

Re: Set analysis help