Nprinting Excel Report Page

[Anonymous]

Hello everyone

I have a field in QlikView, which has the status field list always be filtered by a value when executing a report Nrprinintg must run with the field values with some of the field values, not only with the this filtering.

that is, when the report is run, the filter should not depend on the field, I do a page for reporting excel for each field value

thank you,

[Stephen_Jasionowski]

Andres - I'm not entirely sure of what you are trying to do but if you want to split out data across worksheets for each value of a particular dimension, you can use the Page feature in an Excel template.

See this tutorial and let me know if you are looking to do something else: How to Use the Page Feature in Excel and PowerPoint Report Templates

[Anonymous]

hi, thanks,

that is clear, the problem is that when generating the report and the page field area with the condition of the list box always a value selected in the worksheet only appears that this filtered

[Daniel_Jenkins]

Hi Andres,

I would say that this is working as expected. Without involving NPrinting for a moment, let us consider a QVW with Always One Selected Value enabled on a list box for a field. Clicking "Clear" will not clear that selection - in fact it will not even revert to the original selected value. It is the same when using the QVW in NPrinting and that is why you will get reports filtered for only the selected value. I suggest that if you cannot disable Always One Selected Value make a copy of your QVW, you can use binary load to populate the data from the original, disable Always One Selected Value from this copy and use it as the source.

HTH - Daniel.