NPrinting Pixel Perfect Formatting rule colour by number not working

[lanlizgu]

I am using the NPrinting formatting rules of Pixel Perfect so I could have negative values painted in red and positive numbers in black. However, the feature of NPrinting is not working.

Please find below the example.

I m generating the following report, I want to apply the rule for each cell

The condition is the following one (I tried with 0 and '0' and adding the data member without success):

In example below I applied the formatting rule for a cell inside the Detail2 (with the same formula as in the formatting rule) and it is not working, as it is considering all figures as negatives...

Any help?

[Ruggero_Piccoli]

Hi,

You can apply formatting rules to total and subtotal cells as you do for other cells. Click on the smart tag > icon and add the rule or create a new one.

Maybe I have not understand your issue with formatting rules applied on totals.

Best Regards,

Ruggero

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

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. 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.

[lanlizgu]

The rule used for the levels doesn't work for the sub totals, as it draws the subtotal with the information of the last sub level information.

[Ruggero_Piccoli]

Hi,

Remember to set the Data Member before to start to write the Condition.

For the detail rows create a Condition base don the details. Something like FieldsName >= Value.

For the summary cells write a Condition with the same summary function. For example, sum(FieldName) >= Value.

Don't use the same condition for both kinds of rows.

Best Regards,

Ruggero

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

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. 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.

[Ruggero_Piccoli]

Hi,

You added two more messages and after you deleted them. Do you need more help?

Best Regards,

Ruggero

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

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. 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.

[lanlizgu · Accepted solution]

Hi Ruggerio, thank you for all

I finally got it to work as I mentioned in the other thread.

"

The conditions were correct, but the thing of having a condition for the levels, another one for the subtotals and another one for the totals is very time consuming and frustrating, as you need to check every part of each cell for each line.

Therefore, I have 3 conditions for each line and field (3 levels (line level, sub total and total) * 9 fields * 6 tables = 162 conditions)

The condition of the sub totals with a simple sum for each operation  is enough, and for the totals it is not possible to do through NPrinting features, so I had to add a detailed report and add a table just containing the totals so I could add this final total line.

"