topic Re: OR in Expression in QlikView

OR in Expression

evansabres — Wed, 14 Sep 2016 15:57:00 GMT

I have an expression that is structured as such:

=SUM({$<promoCDE={"MP1"}>}[Net Sold Qty])

However, I have several 'promoCDE' types that begin with MP that are the same as MP1 (MP1, MP1BOX, MP3, MP3BOX, MP6)

I want to build in the expression to pull all of these. How do I structure that using an OR statement???

Re: OR in Expression

sunny_talwar — Wed, 14 Sep 2016 15:58:20 GMT

Try with wildcard search:

=Sum({$<promoCDE={'MP*'}>}[Net Sold Qty])

Re: OR in Expression

evansabres — Wed, 14 Sep 2016 16:00:17 GMT

That works perfectly, thank you for your help

Re: OR in Expression

evansabres — Wed, 14 Sep 2016 16:10:45 GMT

That worked perfectly. Say however that I wanted to include several 'promoCDE' within this expression For example, if I wanted to include the promoCDE's of '2FAMPK' 'GR' 'YTHHOC'

How would I structure this using an OR statement??

Re: OR in Expression

sunny_talwar — Wed, 14 Sep 2016 16:12:21 GMT

Then you can do this:

=Sum({$<promoCDE = {'2FAMPK', 'GR', 'YTHHOC'}>}[Net Sold Qty])