topic Re: Where Statement in QlikView

Where Statement

Mon, 08 Jun 2015 18:47:44 GMT

Hello,

I am trying to exclude certain data from a QVD and am having issues - thus far i have indicated in the where statement that i need the material number to be < and > a specific number. i have also indicated that the brand must = 'A' or 'B' or 'C'. Now i am trying to exclude a subcategory but it will not work for some reason. I have used both 'AND' and 'OR' - the spare parts fall within each brand, i just do not want to see spare parts.

Any ideas as to what i am missing?

Thanks for your help,

Parrish

Re: Where Statement

m_woolf — Mon, 08 Jun 2015 18:49:50 GMT

Please provide your where clause.

Re: Where Statement

Mon, 08 Jun 2015 18:56:37 GMT

Where MATERIAL_NUMBER > 999999 and MATERIAL_NUMBER<10000000 and Brand='A' or Brand='B' or Brand='F' and Product <>'Spare Parts';

Re: Where Statement

maxgro — Mon, 08 Jun 2015 18:56:44 GMT

from your description it should be

where

matnum > 10 and matnum <20

and match(brand, 'A', 'B', 'C')

and not match(subcat, 100)

Re: Where Statement

Mon, 08 Jun 2015 19:08:43 GMT

the and match worked but not the not match - after i closed the match function, i just went back to doing subcat<>'A' and that worked. thank you for the help

Re: Where Statement

Clever_Anjos — Mon, 08 Jun 2015 20:46:22 GMT

Where MATERIAL_NUMBER > 999999 and MATERIAL_NUMBER<10000000

and Match(Brand,'A','B','F')

and Product <>'Spare Parts';

Be careful when mixing AND and OR

OR clauses are evaluated after AND clauses

True And False Or True // evaluates true