Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

sweetu153
New Contributor III

How to change color of qlikview variable in Nprinting

Hi All, I have a variance variable in qlikview. This variable is importing into Nprinting 16.0. I want the color of text to be in RED if variance value is negative. Is it possible to achieve this from Nprinting? If so please advice. It is ok, if color can be changed in QLIKVIEW and gets import into in Nprinting as well. Thanks to advice. Regards, Krishna Chaitanya B.

3 Replies
Employee
Employee

Re: How to change color of qlikview variable in Nprinting

You can use the formatting features of the report type you are using. For example, if you are creating an Excel template you can use Excel formatting features to manage the color based on the variable value. For more details refer to the official help site Applying Excel formatting ‒ Qlik NPrinting.

You cannot import the variable color from QlikView to NPrinting.

Best Regards,

Ruggero

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

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.



Best Regards,
Ruggero
---------------------------------------------
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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
sweetu153
New Contributor III

Re: How to change color of qlikview variable in Nprinting

Sorry, I forgot to mention, We are using Word report due to page restriction. Krishna Chaitanya B

Employee
Employee

Re: How to change color of qlikview variable in Nprinting

Ok,Word doesn't give you the possibility to conditionally change the color of a value.

In this case I suggest you to create a QlikView object, refresh the connection cache and import the new, formatted, object as an image or table in the template.

Best Regards,

Ruggero

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

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.



Best Regards,
Ruggero
---------------------------------------------
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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
Community Browser