Conditional formatting based on table column values AND formulas

[ryk_budzynski]

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.

[Lech_Miszkiewicz]

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

[ryk_budzynski]

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.

[Ruggero_Piccoli]

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-nu...

- https://community.qlik.com/t5/Qlik-NPrinting-Documents/How-to-Manage-PixelPerfect-Conditional-Output...

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

[Lech_Miszkiewicz]

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])....

[Ruggero_Piccoli]

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