Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

adilh1003
New Contributor II

Need to get the exact cell value inexcel template in N Printing

Hi Experts

I need to get the exact cell value from the chart by using referencing in excel template to use it in other sheet to create a new report.

img1.JPG

But as soon as i do preview the cell reference A4 automatically changes to some other value as the chart expands.

img2.JPG

Please help me if there is any possible way to get the exact value from the chart.

Regards

Adil

4 Replies
sbbazaldua0826
New Contributor

Re: Need to get the exact cell value inexcel template in N Printing

Have you tried to use the "cell by cell" option in NPrinting for the chart?

If the exact value (to create your reference) is always populated in the same location in your chart (CH101) it might be the better option instead of dragging and dropping the whole chart itself into the excel template. This will alleviate your issue of the chart expanding since you are grabbing the "cell of data" that you need.

adilh1003
New Contributor II

Re: Need to get the exact cell value inexcel template in N Printing

Hi Samuel

Thanks for your reply.

I tried the same as suggested by you but i am not able to get the correct values from the cell instead it is giving the name of the cell which we put while adding the cell.It will be of great help if you can provide me some example of it with screenshots.

However i am able to get the exact cell value of a chart by using an excel function INDIRECT().

If we need any cell value from a chart we need to get the reference from the preview of the excel as the chart gets expanded there and use the INDIRECT() function.

For Example

img1.JPG

If the A2 value gets generated in the preview and after the chart expansion, we can use the following to get the value

=INDIRECT("Sheet2!A2") in the desired cell. Here i needed in different sheet so i used Sheet2.

img2.JPG

Regards

Adil

Employee
Employee

Re: Need to get the exact cell value inexcel template in N Printing

Hi Adil,

Not sure why you need INDIRECT here. =INDIRECT("Sheet2!A2") is the same as =Sheet2!A2

To give a simple example:

Cell A5 contains the formula =INDIRECT(A2). The value in cell A2 is the string B3 so the result in cell A5 is the value of cell B3 which is 10. So, INDIRECT() returns the reference specified by a text string. Both =INDIRECT("A2") and =A2 will return the text string B3.

If you upload a small project (NSQ, QVW & Excel Template) showing what you currently get and a sample Excel file showing what you want, someone here will assist.

HTH - Daniel.

adilh1003
New Contributor II

Re: Need to get the exact cell value inexcel template in N Printing

Hi Daniel

Thanks for your reply.

Since INDIRECT() function is used to create a reference that won't change if row or columns are inserted in the worksheet. So we will use the reference in the template of the cells of the charts after doing the preview so that we can get the exact value of the cells in the charts, it wont get change even after doing the preview.

The only concern i am facing is the same thing i am not able to do by using "Importing cell values from QlikView objects" as described in the below link.

https://help.qlik.com/en-US/nprinting/17.1/Content/ExcelReports/SelectedQVCellValuesUsedExcelReports...

Regards

Adil

Community Browser