Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

qlikpritamdeb
New Contributor II

NPritning - PPT - Legend Renaming

 

Hi All,

 

Request to help to solve issue regarding NPrinting reports.

 

We have following straight table in Qlikview:

 

date

Test1 A

Test2 A

Test1 B

Test2 B

10/1/2017

100

200

400

200

10/2/2017

200

400

100

200

 

 

We are creating PPT (Line Chart) using above table through  NPrinting.

 

Let us say if we are referencing above table for creating two different slides in PPT

 

In first graph date and Test1 A, Test2 A

 

And in the second graph date and Test1 B, Test2 B

 

The legend in the graph are displayed according to the expression name used in Qlikview (ie Test1 A, Test2 B etc)

 

But we want the legend to be displayed as Test1, Test2 for both the slides

 

We have tried changing the description name in NPrinting but it did not work.

 

Waiting for reply. Thank You in advance!

 

Tags (1)
4 Replies
Lech_Miszkiewicz
Honored Contributor III

Re: NPritning - PPT - Legend Renaming

Hi,

I achieved the same by changing the series labels in XLS char supporting file when creating NPrinting Template.

See all screenshots for details andattached test ppt file:

cheers

Lech

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

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.

1.png

2.png3.png4.png5.png6.png

regards

Lech

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
qlikpritamdeb
New Contributor II

Re: NPritning - PPT - Legend Renaming

Hi Lech,

Thank You for the reply!

Even I am following the same approach still I not getting the desired output.

Also, I tried with unchecking the 'Keep Source format' but that also did not helped.

In the above query I have given example for only two set (ie Test1 A, Test2 A and Test1 B, Test2 B) but originally in the application we have six set(total 47 expression).

Regards,

Pritam Deb

Lech_Miszkiewicz
Honored Contributor III

Re: NPritning - PPT - Legend Renaming

I am not sure if it makes any difference but...

  • on my last 2 screenshots on top orange powerpoint ribbon you see a "disk" icon to "save"(right above Home, Insert" section i PowerPoint). I have used this to keep saving my PPT template each time i have changed label..

This is just shot in darknes - i am not sure if it will help.

regards

Lech

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
qlikpritamdeb
New Contributor II

Re: NPritning - PPT - Legend Renaming

Hi Lech,

Thank You for replying.

I tried saving the PPT as well but it did not worked

Regards,

Pritam Deb

Community Browser