topic Conditional formatting of Expressions in a Straight Table in QlikView

Conditional formatting of Expressions in a Straight Table

Anonymous — Mon, 30 Aug 2010 07:17:52 GMT

Hi Experts

I am using QlikView 8.5 Developer.

I have a Straight Table with 3 Expressions and 1 Dimension.

I would like to format one of the 3 expressions (i.e. Bold) whenever i make a selection of a certain field (which is not the dimension in the table).

I know that I can format a certain expression using "Custom Format Cells" but it cannot be conditional.

Is there a way to do it via Macro?

* The only solution I found so far is to create 3 straight tables with different formatting and conditional show.

Thanks,

Yaniv

Conditional formatting of Expressions in a Straight Table

Mon, 30 Aug 2010 07:58:57 GMT

Hi,

Please look at the attachment, I have defined condition for text color.you can define the same for Text format.

Hope this will work.

Conditional formatting of Expressions in a Straight Table

Anonymous — Mon, 30 Aug 2010 08:32:20 GMT

Hi Santosh

Thanks for the reply! It is really helpfull for me.

Instead of using Different Colors, I would like to use Bold font. I guess that I would need to use "Text Format" instead of "Text Color" but I can't find the relevant fucntion.

In your attachment, you used the function blue(), is there a function for Bold?

Thanks,

Yaniv

Conditional formatting of Expressions in a Straight Table

Mon, 30 Aug 2010 08:54:37 GMT

you can use '' for bold '' for underline '' for bold & underline '' for bold & italic & so on

Conditional formatting of Expressions in a Straight Table

Anonymous — Mon, 30 Aug 2010 09:24:10 GMT

Your answer has been really helpfull.

Many Thanks,

Yaniv

Conditional formatting of Expressions in a Straight Table

Thu, 11 Nov 2010 14:58:45 GMT

Hi, Santosh,

I am also trying to get bold in Text Format for an expression, but I cannot make any function work. This is the syntax I tried based on your post, but it doesn't work:

if(company='NEATOT',(),)

The same syntax works with blue in the Text Colour definition but the above does not work. I'm sure I'm missing something.

Can you help, please?

Diane

Conditional formatting of Expressions in a Straight Table

kji — Thu, 11 Nov 2010 15:32:33 GMT

if(company='NEATOT','','')

Re: Conditional formatting of Expressions in a Straight Table

Fri, 18 Jan 2013 19:34:11 GMT

Is there any way to do double underline for specific rows? Is that an option that is available in qlikview?