topic Re: This OR This AND That OR That in QlikView

This OR This AND That OR That

Anonymous — Wed, 14 Jan 2015 01:11:48 GMT

Puzzled. I want to see a locations that have part "a"OR part "b", AND also have part "c" OR part "d" This does not seem to work. I thought it would return when site had either 170200-00 OR 170203-00 AND also had either 170700-00 OR 170698-00. I know it works with the a single OR on either side - just not when OR on both sides. COUNT({*< Product_Movex_Part_Number={'170203-00'}, Product_Movex_Part_Number={'170700-00'}>*}SVMXC_Site_Id_Key)

Re: This OR This AND That OR That

Peter_Cammaert — Wed, 14 Jan 2015 01:44:47 GMT

I know it can be done with an AND-field listbox and some grouping of products. But I do not know if this is possible with set analysis. Set analysis returns records that comply with the set specifications, and I guess a single record will never contain two products at the same time...

Re: This OR This AND That OR That

Anonymous — Wed, 14 Jan 2015 02:06:34 GMT

COUNT({*< Product_Movex_Part_Number={'170203-00'},Product_Movex_Part_Number={'170700-00'}>*}SVMXC_Site_Id_Key) Never pastes correctly for me here.

Re: This OR This AND That OR That

Anonymous — Wed, 14 Jan 2015 02:07:13 GMT

COUNT({*< Product_Movex_Part_Number={'170203-00'},Product_Movex_Part_Number={'170700-00'}>*}SVMXC_Site_Id_Key)

Re: This OR This AND That OR That

Wed, 14 Jan 2015 03:55:02 GMT

COUNT({*< Product_Movex_Part_Number={170203-00,170700-00}>*}SVMXC_Site_Id_Key)

Re: This OR This AND That OR That

jonathandienst — Wed, 14 Jan 2015 05:38:41 GMT

Use an intersection for the AND part, like this:

COUNT({<Product_Movex_Part_Number={'170200-00', '170203-00'}>*<Product_Movex_Part_Number={'170700-00', '170698-00''}>} SVMXC_Site_Id_Key)

HTH

Jonathan

Re: This OR This AND That OR That

Anonymous — Wed, 14 Jan 2015 21:23:06 GMT

Thank you, that was it.