Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikcurious
Contributor II
Contributor II

Qlik Nprinting powerpoint color using master measure

I am using master measures in Qlik Sense to create a bar chart and the master measure has a color applied. In Nprinting I am bringing this into a table object. The "Keep source format" is checked, however the color set in the Qlik Sense chart is not seen in the Nprinting chart. I want to be able to add expressions to set the color, as doing it manually is very cumbersome. If this is not possible, is there a syntax available to set the color when the "Keep source format" is unchecked?

Please let me know.

Labels (2)
1 Solution

Accepted Solutions
Frank_S
Support
Support

@qlikcurious 

Check my updated response above. You can use straight tables and maintain colors.

I checked with R&D and pivot tables (as mentioned here https://help.qlik.com/en-US/nprinting/February2021/Content/NPrinting/ReportsDevelopment/Qlik-objects...) and other chart types - straight tables being the exception - have the same limitations

We are having the link above updated accordingly.

Sorry I can't give you better news on this.

kind regards...

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

9 Replies
ajsjoshua
Specialist
Specialist

Hi,

In master measure we can only set measure color. I think your requirement is to change the font color.

 

Regards,

Joshua.

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

you are confusing me: 

In Nprinting I am bringing this into a table object. The "Keep source format" is checked, however the color set in the Qlik Sense chart is not seen in the Nprinting chart. 

is it a table or chart?

When you convert in your QlikSense chart to a table do you get the results you want directly in Qlik Sense table? I belive you dont as a measure color does not translate to background colour of value in the table.

In my opinion the only way to have expressionbased colour of values/background in PPT Table is by having Qlik Sense table with the format set and using table object as source for NPrinting PPT report.

 

PowerPoint does not support conditional formatting so you cannot do it directly in PPT

cheers

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
qlikcurious
Contributor II
Contributor II
Author

Hi Lech,

Thanks for the reply. I created a Qlik Sense chart and that chart has master measures with colors. Alternatively, I tried to add colors to the bars in the Qlik Sense chart as well, instead of adding the colors at the master measure level. After this chart is created in QS, in NPrinting, under tables, I add this object ID and create a bar graph using these measures. The colors are lost when I add a bar graph in Nprinting. Adding colors for each of the bars manually is time consuming, hence I wanted to know how do I preserve the colors in NPrinting. 

Frank_S
Support
Support

 

@qlikcurious 


I think your best bet is to export your chart as an image object rather than as a table/chart object.

color export.PNG

There are limitations but it looks like the list of limitations needs to be expanded.

Here are the officially listed limitations.

https://help.qlik.com/en-US/nprinting/February2021/Content/NPrinting/ReportsDevelopment/Qlik-objects...

It appears that the pivot table chart limitations listed will also apply to your bar charts in all likelihood. I am checking with R&D and will be having the above link updated accordingly.

Now if you need something color coded, you can use straight tables to do this...straight tables do not appear to be affected by this limitation affecting pivot and other QS chart types.

See image below:
Table charts color can be exported in this way.PNG

Kind regards...

 

 

 

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
qlikcurious
Contributor II
Contributor II
Author

Thanks @Frank_S . Unfortunately, using an image also has its limitations while resizing the chart in PPT.  i appreciate your help in checking with R&D.

Frank_S
Support
Support

@qlikcurious 

Check my updated response above. You can use straight tables and maintain colors.

I checked with R&D and pivot tables (as mentioned here https://help.qlik.com/en-US/nprinting/February2021/Content/NPrinting/ReportsDevelopment/Qlik-objects...) and other chart types - straight tables being the exception - have the same limitations

We are having the link above updated accordingly.

Sorry I can't give you better news on this.

kind regards...

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
qlikcurious
Contributor II
Contributor II
Author

 Hi @Frank_S , thanks for the update. It seems that the colors are being retained on a straight table in NPrinting. Thats good to know. 

Can you please advise on the syntax of the format when "keep source format" is unchecked? I wanted to see if colors can be added there.

I have attached a screenshot on the highlighted section I have the question on.

 

Frank_S
Support
Support

@qlikcurious 

 

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
qlikcurious
Contributor II
Contributor II
Author

Thanks @Frank_S  for the reply.