Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

narender123
Valued Contributor

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_miszkiewic
Honored Contributor III

Re: Report header and current selection in Nprinting 17.0

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

8 Replies
lech_miszkiewic
Honored Contributor III

Re: Report header and current selection in Nprinting 17.0

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

narender123
Valued Contributor

Re: Report header and current selection in Nprinting 17.0

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_miszkiewic
Honored Contributor III

Re: Report header and current selection in Nprinting 17.0

  • 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

narender123
Valued Contributor

Re: Report header and current selection in Nprinting 17.0

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_miszkiewic
Honored Contributor III

Re: Report header and current selection in Nprinting 17.0

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

are we talking about a total marked below?

cheers

Lech

np1.png

narender123
Valued Contributor

Re: Report header and current selection in Nprinting 17.0

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_miszkiewic
Honored Contributor III

Re: Report header and current selection in Nprinting 17.0

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

narender123
Valued Contributor

Re: Report header and current selection in Nprinting 17.0

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

Community Browser