Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
narender123
Specialist
Specialist

Report header and current selection in Nprinting 17.0

Hi All,

I have created a report in Qlikview .Below is the print preview of the Qlikview report.

image.jpg

Now in Nprinting, I am creating an excel format report. After creation of a task in Nprinting I am getting the Qlikview report without header and current selection. I want the report just like above as I can see the report in print preview section of QlikView report.

Tell me how to achieve this.

thanks,

Narender

1 Solution

Accepted Solutions
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi I have reolied to this in your other post regarding this

Send email in Nprinting Version 17.3.0.

Remember that filters are not applied in PREVIEW and NPrinting 17 CLEARS all selection before generating anything.

You should be able to see selection once you use publish task with filtrers applied.

regards

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

12 Replies
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi I have reolied to this in your other post regarding this

Send email in Nprinting Version 17.3.0.

Remember that filters are not applied in PREVIEW and NPrinting 17 CLEARS all selection before generating anything.

You should be able to see selection once you use publish task with filtrers applied.

regards

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
narender123
Specialist
Specialist
Author

Hello Lech,

Now it's working.

As I am new in 17 version so I am asking multiple questions.

I have also noted that Total amount of Qlikview report are not showing in nprinting17. I need to show report with the total amount as in QlikView report.

In trigger how I can set the report as per my system time as UTC 6:00 Central America not available in  Nprinting17 time zone.

Thanks,

Narender

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

  • regarding totals - are you referring to chart you have in this post (above) where totals are on right hand side (as a column)?
    • there may be 2 different solutions for that (again depending on NPrinting template type)
      • 1. creating a table and generating subtotal as an excel
      • 2. Building a grouping dimension in  QlikView model (this will group everything in your table according to granularity) and would be represented as a total - i posted about this technique in QlikSense forum here:Re: How to add a second total row in straight table?

  • regardsing TimeZone - what do you mean that there is not UTC 6:00 Central America timezone? Maybe search under America&City?

np1.png

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
narender123
Specialist
Specialist
Author

Hi Lech,

I think you did not get my point.

I have to show the QlikView report in Nprinting . Nprinting not showing total column but total column is in Qlikview dashboard report.As shown previously in image.

So how I can show exactly same table as of Qlikview dashboard report including Total.

Please note, I am using excel template in report.

Thanks,

Narender

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

just to confirm - is this a pivot table in QlikView?

are we talking about a total marked below?

cheers

Lech

np1.png

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
narender123
Specialist
Specialist
Author

Yes, It is Pivot table and I talking about Total as shown in image.

But in some table i have straight table where it is also not showing total column.

Thanks,

Narender

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

I understand - the thing with NPrinting is that not all options from QlikView will be available just as they are in QlikView and we will have to deal with it with workarounds.

I need to do some testing regarding this - maybe just open second thread for it and we will move conversation there.

ps. how about timezone? did you fin right one in between all available there?

cheers

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
narender123
Specialist
Specialist
Author

Thanks, Lech.

I have created a new thread regarding total column issue and I will let you know about time zone.

https://community.qlik.com/message/1265354#1265354

t_nikhilareddy
Contributor II
Contributor II

Hi Lech,

I saw what you said, that NPrinting will clear all the selections before generating any report - want to confirm on this.

I have so many default selections made on each sheet in qlikview dashboard and also have always one selected value in some of the list boxes in some sheets. I'm trying to generate a report in Nprinting and I see no filters from dashboard are being applied in the NPrinting. Is this how Nprinting works with filters (no default filters from QV dashboard will be automatically carry forwarded to NPrinting without applying task filters in Nprinting) ? If so is there any work around to achieve this?

Because we have so many filters applied in each sheet which makes it difficult for us to always create filters in NPrinting and apply them while generating a report.

Any suggestion here is greatly appreciated!

Thanks,

Nikhila