Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Publish reducing only not creating several files

Hi,

Is it possible to reduce a document with publisher but without generating several documents?

I mean, I have a field to do the reducing, but I prefer to publish one document instead of several, that way I don't need to manage users in the management console and I have only 1 doc copied to the server.

Thanks in advance

11 Replies
giakoum
Honored Contributor II

Re: Publish reducing only not creating several files

it is called simple reduce. based on one value of a field. hope this is what you mean

Capture1.PNG

Not applicable

Re: Publish reducing only not creating several files

True, sorry, I forget to add that I'd like to do it without selecting the values. For the simple reduce you need to select the field and field values. Is there any way to do it for all values dynamically?

Thanks

giakoum
Honored Contributor II

Re: Publish reducing only not creating several files

I don't quite follow. If you select all values, it is like reducing it for all except the null ones I guess. Could you please elaborate?

Not applicable

Re: Publish reducing only not creating several files

Yes.

What I want is to reduce for all values in that field, but this doesn't mean it's the whole document data due to there are null values as well. Imagine the doc contains info for several customers, and I want to reduce it only for the ones I specify on the field. I only was able to loop and reduce getting several filtered docs but not reduce only in 1 doc.

Is that possible?

Thanks!

Employee
Employee

Re: Publish reducing only not creating several files

Hi,

ioannis giakoumakis gave the correct answer to your question.

Bill

Not applicable

Re: Publish reducing only not creating several files

No he did not, because it is mandatory to select values in order to have the reduce, so basically when new values are added then I need to change the task and select them.

My question is if it is possible to reduce without selecting the values as in the loop and reduce but without generating several files.

Thanks

MVP
MVP

Re: Publish reducing only not creating several files

Simple reduce would not loop to create multiple documents. However, you have to select your desired field values. Alternatively may be, you can try like:

Select the desired values in the field and create a Bookmark. Then use publisher to reduce by bookmark.

Not applicable

Re: Publish reducing only not creating several files

Could not understand your requirement.

If you don't want NULL values or you have a logic to get the field values for which the file should contain data. Do that in your data model scripting (Where conditions or Joins).

Regards,

KKR

Not applicable

Re: Publish reducing only not creating several files

Hi,

@Tresesco But then you are still selecting values and the bookmark will save those values, but not the new ones.

@Kranthikumar M Those values are added using an excel file, but this is not important.

I'll try to reformulate my question. Is there any way to get one document published and filtered by values coming from a field WITHOUT the need of selecting them previously, only adding them into an excel file and without doing a binary load from another document? Does publisher have this possibility?

Many Thanks

Community Browser