Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

agigliotti
Honored Contributor II

Publisher Simple Reduce using "OR" operator

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

Tags (3)
9 Replies
stabben23
Honored Contributor

Re: Publisher Simple Reduce using "OR" operator

Hi,

Why dont you put in a where statment?

//Staffan

agigliotti
Honored Contributor II

Re: Publisher Simple Reduce using "OR" operator

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

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

stabben23
Honored Contributor

Re: Publisher Simple Reduce using "OR" operator

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

//Staffan

agigliotti
Honored Contributor II

Re: Publisher Simple Reduce using "OR" operator

Yes but how I can ?

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

stabben23
Honored Contributor

Re: Publisher Simple Reduce using "OR" operator

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?

agigliotti
Honored Contributor II

Re: Publisher Simple Reduce using "OR" operator

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

stabben23
Honored Contributor

Re: Publisher Simple Reduce using "OR" operator

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

agigliotti
Honored Contributor II

Re: Publisher Simple Reduce using "OR" operator

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 ?

AG

stabben23
Honored Contributor

Re: Publisher Simple Reduce using "OR" operator

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

//Staffan

Community Browser