topic Sparkline tool in Nprinting September 2017- work just for first row in a table in Qlik NPrinting

Sparkline tool in Nprinting September 2017- work just for first row in a table

jasmina_karcic — Tue, 27 Feb 2018 13:02:00 GMT

Hi,

I am trying to make a report in Nprinting, version September 2017. I am using Excel template.

I need to put sparkline column in a table. When I put it, it cannot be filled for all rows in table. Just in one row. What can I do?

How I set:

What I get:

Thanks,

Jasmina

Re: Sparkline tool in Nprinting September 2017- work just for first row in a table

Chanty4u — Tue, 27 Feb 2018 13:11:59 GMT

only for that particular column? or others also.

try this- add two or three random values to that column and add <deleterow> for that random data ans select this range also

and try

Re: Sparkline tool in Nprinting September 2017- work just for first row in a table

jasmina_karcic — Tue, 27 Feb 2018 13:21:09 GMT

This still doesn't work.

Jasmina

Re: Sparkline tool in Nprinting September 2017- work just for first row in a table

jasmina_karcic — Tue, 27 Feb 2018 13:24:48 GMT

This is okay, when insert some rows...but i need to print automatically rows and automatically fill sparkline column...

Jasmina

Re: Sparkline tool in Nprinting September 2017- work just for first row in a table

Chanty4u — Tue, 27 Feb 2018 13:42:28 GMT

yes after this what you got output?

Re: Sparkline tool in Nprinting September 2017- work just for first row in a table

jasmina_karcic — Tue, 27 Feb 2018 13:51:09 GMT

Just in first level for inserted rows...:/

Re: Sparkline tool in Nprinting September 2017- work just for first row in a table

Chanty4u — Tue, 27 Feb 2018 13:52:31 GMT

do you have data for that?

and check the base sheet data in output file . and see how many rows it is selecting?

Re: Sparkline tool in Nprinting September 2017- work just for first row in a table

jasmina_karcic — Tue, 27 Feb 2018 14:04:47 GMT

I have data...

How can I check the base sheet data in output file?

Jasmina

Re: Sparkline tool in Nprinting September 2017- work just for first row in a table

Chanty4u — Tue, 27 Feb 2018 14:05:47 GMT

are you using custom template or direct table you are dragging into designer?

Re: Sparkline tool in Nprinting September 2017- work just for first row in a table

jasmina_karcic — Tue, 27 Feb 2018 14:12:08 GMT

i am using custom template...

and i drag table

Re: Sparkline tool in Nprinting September 2017- work just for first row in a table

Ruggero_Piccoli — Wed, 28 Feb 2018 11:05:36 GMT

Hi,

I created a simple example to try to reproduce your issue but mine works fine.

In the Excel file that you obtain from the preview, please try to manually add some sparklines in the cells where they are not added during the report production. I would to check if you get some specific Excel errors.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: Sparkline tool in Nprinting September 2017- work just for first row in a table

jasmina_karcic — Wed, 28 Feb 2018 11:56:56 GMT

In output document just first row in the first level is printed with sparkline. Then, I can manually put down to all rows and I will get in all rows in the first level. But I want it is printed for all rows automatically.

For all other levels I cannot do anything.

Thanks for help,

Jasmina

Re: Sparkline tool in Nprinting September 2017- work just for first row in a table

Ruggero_Piccoli — Wed, 28 Feb 2018 13:41:13 GMT

Of course it must print the sparklines automatically on all rows. I would to be sure that there are not issues in the data or in Excel.

At this point I suggest you to open a support ticket so my colleagues can organize a remote session with you and check directly your Excel template. Remember to add a link to this conversation in the ticket.

As alternative you can evaluate to create a PixelPerfect template https://help.qlik.com/en-US/nprinting/February2018/Content/PixelPerfectReports/HowUseSparklinesPixelPerfectReports/Spark…

Best Regards,

Ruggero

---------------------------------------------

Re: Sparkline tool in Nprinting September 2017- work just for first row in a table

jasmina_karcic — Wed, 28 Feb 2018 13:55:08 GMT

You mean I should write to Qlik Support? Open a new case?

Hmmm i didn't make any pixel perfect report. I think it cannot be realised like an excel document. I need to create excel document, that is the point. But I would like to learn working with pixel perfect. I am interested in all about Qlik Sense and Nprinting.

I am happy because you help me now. Thank you a lot.

Jasmina

Re: Sparkline tool in Nprinting September 2017- work just for first row in a table

jasmina_karcic — Wed, 28 Feb 2018 14:10:02 GMT

I have logged a case.

01344918

Is this what you asked for?

Re: Sparkline tool in Nprinting September 2017- work just for first row in a table

Ruggero_Piccoli — Wed, 28 Feb 2018 14:49:50 GMT

Good!

Re: Sparkline tool in Nprinting September 2017- work just for first row in a table

Ruggero_Piccoli — Wed, 28 Feb 2018 14:51:10 GMT

I hope that we will be able to find a solution thanks to a deeper investigation.

Best,

Ruggero

Re: Sparkline tool in Nprinting September 2017- work just for first row in a table

jasmina_karcic — Wed, 28 Feb 2018 14:52:45 GMT

Thank you Ruggero, I hope too.

Now I feel that I am not alone in this working.

Best,

Jasmina

Re: Sparkline tool in Nprinting September 2017- work just for first row in a table

sjcuthbertson — Tue, 20 Aug 2019 20:25:42 GMT

Hi @jasmina_karcic - did you get a resolution for this?

I am having the same problem (using NPrinting April 2018 still) with a sparkline in Excel. I don't even have NPrinting report levels; just a single table, but the sparkline will not fill down beyond the first row.

I'm already trying with the <deleterow> trick, and I know I have data for each row - it really does sound like the same problem you described. So I'm keen to know if Qlik Support were able to find you a workaround, or if it's a bug, or something else.

Re: Sparkline tool in Nprinting September 2017- work just for first row in a table

Ruggero_Piccoli — Wed, 21 Aug 2019 08:47:40 GMT

Hi,

Did you used Levels as visible in my post dated 28-02-2018 12:05 PM?

Best Regards,

Ruggero