topic Re: How to export a Bar chart with scroll with all the values in Qlik NPrinting

How to export a Bar chart with scroll with all the values

avinashelite — Mon, 16 Nov 2015 06:19:30 GMT

Hi Experts,

I need to export Bar chart with scroll bar with all the values dynamically in NPrinting . The problem is NPrinting will capture Bar chart as an image. if its a straight table NPrinting will shrike or increase the chart based on the data, do we have any such feature for the bar chart also .

Regards

Avinash R

Re: How to export a Bar chart with scroll with all the values

deepakqlikview_123 — Mon, 16 Nov 2015 06:56:09 GMT

Presentation->enable X axis scroll bar

and put the value as per your chart

Re: How to export a Bar chart with scroll with all the values

avinashelite — Mon, 16 Nov 2015 07:29:04 GMT

Hi Deepak,

Thanks for your reply but requirement is in the NPrinting do we have the option for the auto adjust of the height ? so that if my chart has 10 or 1 values its height will get adjusted automatically .

Re: How to export a Bar chart with scroll with all the values

deepakqlikview_123 — Mon, 16 Nov 2015 08:14:00 GMT

Hi Avinash,

I have no idea about n printing but qlikviw sets chart values on y axis dynamically when you can put the chart in smaller view in larger view it can again adjust automatically.

I do not think so there is such kind of option is available may be other experts can suggest you better option for this.

Thanks

Re: How to export a Bar chart with scroll with all the values

avinashelite — Mon, 16 Nov 2015 09:42:18 GMT

ya, Deepak I know this . Lets see any other has the solution for this

Re: How to export a Bar chart with scroll with all the values

jyothish8807 — Mon, 16 Nov 2015 09:48:09 GMT

Hi Avinash,

I don't think it is possible in Nprinting, since Nprinting capture charts as image. You can try pasting the chart as object into excel or ppt. In this case you will get the exact functionality as QV.

Regards

Re: How to export a Bar chart with scroll with all the values

avinashelite — Mon, 16 Nov 2015 09:54:43 GMT

Hi Jyothish,

Thanks for your inputs. The problem is NPrinting will to allow to build a template of excel or word with direct coping of the object ...First we need to import the object to NPrinting and then we need to play around that .. let me try some other approach

Re: How to export a Bar chart with scroll with all the values

jyothish8807 — Mon, 16 Nov 2015 13:32:02 GMT

Hi Avinash,

Yes, that true. But Nprinting doesn't allow dynamic feature to charts. (as per my knowledge). Just simply try to drag and drop the chart from QV to a word or excel file. It will copy the exact object in to word with dynamic functionality.

Regards

Re: How to export a Bar chart with scroll with all the values

Mon, 23 Nov 2015 17:50:58 GMT

Avinash

I read through the thread and it is correct that you caonnot export a bar chart and get the entire chart if there are scroll bars since the chart comes into nprinting as an image.

What you will need to do is bring it in as a table or have a version of it as a table and then once in a table format in the excel tempalte, there are steps to get it converted to a chart.

Currently there are issues with the Help for NPrinting and I cannot send you the link but there is a help topic about making excel charts

Re: How to export a Bar chart with scroll with all the values

Mon, 23 Nov 2015 20:57:52 GMT

Avinash

check out this tutorial - this would give you the bar chart based on the data in QlikView

Re: How to export a Bar chart with scroll with all the values

Daniel_Jenkins — Mon, 23 Nov 2015 21:06:30 GMT

Hi Adam,

Most articles have been successfully moved over. I believe this is the article you are referring to: How to Create MS Excel Charts from Qlikview Data

HTH - Daniel.

Re: How to export a Bar chart with scroll with all the values

avinashelite — Tue, 24 Nov 2015 10:01:52 GMT

Thanks a lot akrepistman‌ but I have build a Gannt Chart with some complex expression and reference line with traffic light feature on top of it ...so it might not be easy to replicate the same in excel ...

Re: How to export a Bar chart with scroll with all the values

Tue, 24 Nov 2015 13:25:26 GMT

Avinash

I see your point - I thought it was a bar or line chart. Is it possible to size it on a tab in Qlikview without scroll bars, even if you have to place it on a tab of its own? If you can do that, then you can use that object without scroll bars as the image and use the NPrinting properties to adjust the size on the report itself, and then hide the tab so the user is not aware of any changes on their end

Re: How to export a Bar chart with scroll with all the values

avinashelite — Wed, 25 Nov 2015 05:49:02 GMT

Hi Adam,

We both are on the same track ...even I taught the same and I have done the same in Qlikview ..NPrinting is capturing the chart properly now

Re: How to export a Bar chart with scroll with all the values

Wed, 25 Nov 2015 12:33:09 GMT

Excellent - glad to hear you have it working