topic Re: NPrinting Formatting Rule in a Formula in Qlik NPrinting

NPrinting Formatting Rule in a Formula

lanlizgu — Wed, 25 Sep 2019 18:40:54 GMT

Hi,

I am trying to apply a formatting rule for a formula, but I am not able to develop this, is it possible to apply a formatting rule for a formula?

I am able to apply formatting rules inside levels but not in formulas.

Thank you.

Re: NPrinting Formatting Rule in a Formula

Ruggero_Piccoli — Mon, 22 Oct 2018 14:33:26 GMT

Hi,,

What kind of report are you developing?

In any case, if with formatting rule you mean for example the number of decimals, I suggest to add Qlik formatting functions directly in the formula.

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.

Re: NPrinting Formatting Rule in a Formula

Lech_Miszkiewicz — Mon, 22 Oct 2018 22:27:33 GMT

Agree with Ruggero,

example would be also helpfull

Re: NPrinting Formatting Rule in a Formula

Ruggero_Piccoli — Tue, 23 Oct 2018 07:09:32 GMT

Yessss! It is very hard to answer to a question with few details like this

Best Regards,

Ruggero

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

Re: NPrinting Formatting Rule in a Formula

lanlizgu — Tue, 23 Oct 2018 09:04:19 GMT

Hi Ruggero,

It is for pixel perfect. I am afraid that formatting rules are not available for formulas in pixel perfect.

At the end I imported the data as a table so I could edit the formatting rules.

Thank you.

Re: NPrinting Formatting Rule in a Formula

Ruggero_Piccoli — Tue, 23 Oct 2018 09:49:22 GMT

Hi,

In a PixelPerfect template you can create a formatting rule in the meaning that the format of a cell changes if a condition is true.

Click on the smart tag and open the Formatting rule menu

Then use the formula editor to create the rule. You can use the fields that are available in the Levels node.

Best Regards,

Ruggero

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

Re: NPrinting Formatting Rule in a Formula

lanlizgu — Tue, 23 Oct 2018 10:34:54 GMT

Ruggero, I know how the formatting rule works. The thing is that as you mentioned, this is only for fields in the Levels node and not for tables or formulas.

Therefore, there is a limitaton in the usage of the formatting rule, as in order to use this feature you need to create the data in Levels, as you can't use the data created as tables and/or formulas in this feature.

Thank you.