topic Re: Adding calculated column-problem with automatically filling all rows in a table in Qlik NPrinting

Adding calculated column-problem with automatically filling all rows in a table

jasmina_karcic — Fri, 23 Feb 2018 15:13:08 GMT

Hi everyone,

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

I put a calculated column, and I use a level. But when i want preview a report, then I see that a calculated column is not filled in all rows,

just a first row of all levels.

What can I do?

Thankssss,

Jasmina

Re: Adding calculated column-problem with automatically filling all rows in a table

Chanty4u — Sat, 24 Feb 2018 18:12:43 GMT

add one more row with dummy data along with <deleterow> and select the range the row also and preview

Re: Adding calculated column-problem with automatically filling all rows in a table

Ruggero_Piccoli — Mon, 26 Feb 2018 10:54:37 GMT

Hi,

If you are using levels in an Excel template you must insert the formula to calculate the new columns between the levels tags as in the picture:

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: Adding calculated column-problem with automatically filling all rows in a table

jasmina_karcic — Mon, 26 Feb 2018 13:41:53 GMT

I have already done that but doesn't work

Jasmina

Re: Adding calculated column-problem with automatically filling all rows in a table

Ruggero_Piccoli — Mon, 26 Feb 2018 14:47:21 GMT

Thanks for the screenshot. It seems a bug that appears when you insert an Excel table inside a level. As workaround you can use nested levels:

Best Regards,

Ruggero

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

Re: Adding calculated column-problem with automatically filling all rows in a table

jasmina_karcic — Tue, 27 Feb 2018 12:26:28 GMT

Thank you very much. Now it is working.

But I have another question, maybe you can help me, or I will open an another topic.

Now I need sparkline column.

And the same thing is happening. Just in one row I get result.

Excel doesn't allow me to manipulate with $ in sparkline edit. 😕

Thank you

Jasmina

Re: Adding calculated column-problem with automatically filling all rows in a table

Ruggero_Piccoli — Tue, 27 Feb 2018 12:56:02 GMT

Yes, please open a single conversation for every question. Thanks

Re: Adding calculated column-problem with automatically filling all rows in a table

jasmina_karcic — Tue, 27 Feb 2018 13:03:10 GMT

here is:

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

Re: Adding calculated column-problem with automatically filling all rows in a table

Ruggero_Piccoli — Tue, 08 May 2018 10:14:05 GMT

Hi,

This bug will be solved in next release June 2018.

Best regards,

Ruggero