How to change color of qlikview variable in Nprint... - Qlik Community

Anonymous · ‎2017-09-15

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.

Ruggero_Piccoli · ‎2017-09-15

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.

Anonymous · ‎2017-09-15

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

Ruggero_Piccoli · ‎2017-09-15

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.

How to change color of qlikview variable in Nprinting