NPritning - PPT - Legend Renaming

[qlikpritamdeb]

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!

[Lech_Miszkiewicz]

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.

regards

Lech

[qlikpritamdeb]

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]

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

[qlikpritamdeb]

Hi Lech,

Thank You for replying.

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

Regards,

Pritam Deb