topic Re: align table and chart in excel template in Qlik NPrinting

align table and chart in excel template

ronaldwang — Mon, 11 Sep 2017 04:40:05 GMT

If I put a chart next to a table in the excel template and in the table I use “expand” option for the columns. Then when data is populated in the table, the position of the chart and table will no longer align, as the number of rows to be expanded in the table can vary, what can be done to the chart side to make sure the two objects’ position could still align? I have tried insert the columns behind the chart but still don't work.

Re: align table and chart in excel template

arvind_patil — Mon, 11 Sep 2017 05:11:28 GMT

Hi Ronald,

At the time of table adding into Nprinting Template. Please unchecked Keep Source Format.

May be it works for You

Thanks,

Arvind Patil

Re: align table and chart in excel template

Daniel_Jenkins — Mon, 11 Sep 2017 05:19:21 GMT

Hi Ronald,

It is not clear what behavior you are experiencing. Are you using levels? Are you placing the chart far enough away from the table? Etc.

These links may help:

NPrinting 16 - Chart and table side to side

Inserting a chart as image interferes with the table on the side

A sample QVW/QVF and a mock-up Excel file showing how you expect your output will help.

HTH - Daniel.

Re: align table and chart in excel template

ronaldwang — Mon, 11 Sep 2017 05:28:53 GMT

Hi Patil,

format is unchecked already

Re: align table and chart in excel template

ronaldwang — Mon, 11 Sep 2017 05:33:11 GMT

Hi Daniel,

the template is set up as below, where the start of the table align to the start of the chart next to it.

But as in the table i use expand option, more rows will be inserted to the table thus the result became, and i can not be exact how many rows will be insert thus i can not make the assumption and make adjustment accordingly in the chart.

Re: align table and chart in excel template

Ruggero_Piccoli — Mon, 11 Sep 2017 07:29:01 GMT

Hi Ronald,

Could you post a screenshot of the original template? Thanks

Re: align table and chart in excel template

ronaldwang — Wed, 13 Sep 2017 06:08:45 GMT

Hi Guggero,

the template is as below where the the table and chart align, but as the table has new data input as "expand", the result chart is pushed down as shown in previous chart

Re: align table and chart in excel template

Ruggero_Piccoli — Wed, 13 Sep 2017 13:08:07 GMT

Thanks for the template.

The "Expand range" is a table property, so its value acts only when you add the whole table as a single table into the template. If you unflag the "Expand range" check box and you drag and drop some single columns into the template the option has no effects.

I did some tests and I found two possible solutions:

1 - if you know the number of values of the LOB_TR_3 column you can add it in the Cells node as you did with the visible left part of the template. Then drag and drop each single cell into the template

2 - Disable the "Expand range" for the table, drag and drop it into a different worksheet of your template (you can hide this worksheets when you finish the template development) and insert Excel links (like =+Sheet2!B2) in the final cells.

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: align table and chart in excel template

ronaldwang — Thu, 14 Sep 2017 04:43:24 GMT

Thanks Ruggero,

Option 2 won't work as I I won't be able to predict how many rows from the "expand range" table and when it is possible i want to keep everything in one template.

I am not exact sure if i fully understand your option 1, as the issue is not coming from the number of rows in the LOB_TR_3, the issue is coming from that when the data expand in the left table, the right chart box is skewed down.

Re: align table and chart in excel template

Ruggero_Piccoli — Thu, 14 Sep 2017 08:47:02 GMT

Hi Ronald,

Placing objects side-by-side in Excel templates is always a bit difficult because Qlik NPrinting add rows when filling the final report with data from Qlik.

With option 2 you keep everything in a single Excel template, but in 2 worksheets (you can hide the one with the raw data). Then you can add a lot of rows with Excel link to data in order to be sure that you cover the whole table.

I found another possible solution. You can create a straight table with a dimension and the LOB_TR_3 column. Hide the dimension and save the Qlik document. Refrash the NPrinting cache, add the new table in the Tables node and you should see only the LOB_TR_3 column. Remove the flag on Expand range option, add the table tag (not the LOB column tag) in the report and run a preview.

Best Regards,

Ruggero

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

Re: align table and chart in excel template

sriabt — Mon, 28 Jun 2021 04:57:33 GMT

Thanks this is helping 80% but still the left side table formats are showing upto the right side chart size. For example the left side table value ends upto ROW 6 but the right side chart is showing up to row 15..then the left side table format is showing from Row 7 to Row 15 as extra. Please help to fix this issue.

Re: align table and chart in excel template

Ruggero_Piccoli — Mon, 28 Jun 2021 09:06:56 GMT

Hi,

As general rule, please avoid to comment 3 years and half old conversations because the software could be changed on a so long time. Instead start a new conversation, add all the details needed to reproduce your issue (including screenshots, steps, etc) and the label with the correct version you are using.

In this specific case, the way of working of Qlik NPrinting about how Excel reports are generated is not change so I have very few details but I suspect the old answer is still valid.

Best Regards,

Ruggero

Re: align table and chart in excel template

Frank_S — Mon, 28 Jun 2021 12:47:15 GMT

Further as a new poster her and as potentially a new user of NPrinting, we recommend checking the available NPrinting training pages tutorials and videos available for your convenience.

https://community.qlik.com/t5/Knowledge-Base/Qlik-NPrinting-Training-and-Information-Resources-Step-by-Step/ta-p/1595197