topic Re: Conditional formatting based on table column values AND formulas in Qlik NPrinting

Conditional formatting based on table column values AND formulas

ryk_budzynski — Tue, 17 Mar 2020 20:40:38 GMT

Hi All

I've been able to conditionally format my table columns using hardcoded values (e.g. [Column_Name] < 55) but I can't see how to do it by comparing the column value against a formula (e.g. [Column_Name] < [Formula Name]). The data binding drop down list in table cell tasks only seems to allow choosing formulas OR levels. Is there something I'm missing here?

Thanks, Ryk.

Re: Conditional formatting based on table column values AND formulas

Lech_Miszkiewicz — Thu, 21 Nov 2019 05:57:09 GMT

With this information it is not clear what you are referring to:

Could you please provide following information:

template you are using: Excel, Word, PixelPerfect, HTML?
screenshot of what you are trying to achieve (template and where you are trying to put your comparison to formula)

The above will give us slight indication what are we dealing with here

regards

Lech

Re: Conditional formatting based on table column values AND formulas

ryk_budzynski — Thu, 21 Nov 2019 06:05:16 GMT

Hi Lech

Apologies, it is PixelPerfect.

As an example, see the attached where I'm highlighting the row where Sum(SomeValue) < Avg(Total SumValue).

Thanks, Ryk.

Re: Conditional formatting based on table column values AND formulas

Ruggero_Piccoli — Thu, 21 Nov 2019 15:03:44 GMT

Hi,

In PixelPerfect you need to create a Formatting rule. There are some examples in the articles:

- https://community.qlik.com/t5/Qlik-NPrinting-Documents/Conditionally-display-a-label-based-on-the-number-of-rows-in-a/ta-p/1649688

- https://community.qlik.com/t5/Qlik-NPrinting-Documents/How-to-Manage-PixelPerfect-Conditional-Output-Formats-Using-the/ta-p/1484894

Then you can customize the format as you prefer.

Note that in a condition you can use only fields that are in the level where the condition is applied.

Best Regards,

Ruggero

Re: Conditional formatting based on table column values AND formulas

Lech_Miszkiewicz — Thu, 21 Nov 2019 19:54:56 GMT

As @Ruggero_Piccoli said "Note that in a condition you can use only fields that are in the level where the condition is applied." You need to create additional column in your source data (used in Level) with Avg(TOTAL SomeValue) and then compare Iif([Field]<[Field],True,False])....

Re: Conditional formatting based on table column values AND formulas

Ruggero_Piccoli — Fri, 22 Nov 2019 09:10:30 GMT

Hi,

I agree with @Lech_Miszkiewicz solution. You could also evaluate to add the calculation in the condition:

You need to customize the formula:

Iif([Total Sales] < Avg([Total Sales]),True ,False )

Best Regards,

Ruggero