topic Text Formatting in expressions for certain fields in QlikView

Text Formatting in expressions for certain fields

Fri, 31 Jan 2014 16:49:20 GMT

Hello,

I am trying to format a certain row in my straight table. I am doing this by using the formatting condition, my expression is

IF(Sum({<Transtype={[Total Revenue]}>} Target Revenue),'<b>') this works however I have some expressions as Column(1)-Column(2) how am I able to make those bold for the same transtype i.e Total Revenue?

Thanks in advance

Anna

Re: Text Formatting in expressions for certain fields

Gysbert_Wassenaar — Fri, 31 Jan 2014 17:11:00 GMT

Your expression doesn't really make sense to me. Perhaps this is what you need (for the formatting condition of all expressions): IF(Transtype='[Total Revenue]','<b>')

Re: Text Formatting in expressions for certain fields

Mon, 03 Feb 2014 08:46:53 GMT

this doesn't work on a column where I have an expression i.e. Column(1)-Column(2), it only works in the dimension column which is transtype.

Thanks anyway