topic Re: Publisher Simple Reduce using "OR" operator in QlikView

Publisher Simple Reduce using "OR" operator

agigliotti — Mon, 26 Jan 2026 18:19:17 GMT

Hello,

I have to configure a publisher task with simple reduce using the following condition:

(FIELD1 IN ('01,'02','10','11') OR (FIELD1 = '30' AND FIELD2 = '01'))

How can I achieve it ?

Many thanks in advance.

Best Regards

Andrea

Re: Publisher Simple Reduce using "OR" operator

stabben23 — Thu, 09 Jan 2014 14:27:33 GMT

Hi,

Why dont you put in a where statment?

//Staffan

Re: Publisher Simple Reduce using "OR" operator

agigliotti — Thu, 09 Jan 2014 14:32:35 GMT

because I have several users with different where conditions to apply.

I'm thinking to create one task for each user.

Re: Publisher Simple Reduce using "OR" operator

stabben23 — Thu, 09 Jan 2014 14:43:01 GMT

Ok, can you create a bookmark with these selections? And then use simple reduce with bookmarks.

//Staffan

Re: Publisher Simple Reduce using "OR" operator

agigliotti — Thu, 09 Jan 2014 14:57:28 GMT

Yes but how I can ?

I don't know how is possible using something like OR condition...

Re: Publisher Simple Reduce using "OR" operator

stabben23 — Thu, 09 Jan 2014 15:25:08 GMT

Ok, But will it not give you the same result even if you select Field1=01,02,10,11 or Field1=30 and Field2=01?

Re: Publisher Simple Reduce using "OR" operator

agigliotti — Thu, 09 Jan 2014 15:33:10 GMT

I'll try to be more clear...

Ex. FIELD1 = COMPANY

FIELD2 = COUNTRY

I need to select for the COMPANY = 01-02-10-11 all country while for the COMPANY= 30 only the country = 01

The results are of course different...but I need the UNION of both selections

Re: Publisher Simple Reduce using "OR" operator

stabben23 — Thu, 09 Jan 2014 15:58:10 GMT

But if you reduce the field country with 01 you will only get 01 no matter what. You can not both reduce and keep.

//Staffan

Re: Publisher Simple Reduce using "OR" operator

agigliotti — Thu, 09 Jan 2014 16:09:19 GMT

finally the only way is to create 2 tasks for that user, one using COMPANY = 01,02,10,11 that will create the document_1.qvw and the other task using COMPANY = 03 and COUNTRY = 01 that will create the document_2.qvw

Is this right ?

Re: Publisher Simple Reduce using "OR" operator

stabben23 — Thu, 09 Jan 2014 16:36:07 GMT

That seams to be the only way, in any case in my qv-world.

//Staffan