topic Re: Font color in Pivot in App Development

Font color in Pivot

stekol61 — Fri, 15 Mar 2019 10:31:48 GMT

Hi!

I have data in a pivot table and i have also loaded target values for each record.

If a value in the pivot is below he target the font color should be Red, otherwise it should be Green.

How can this be done in Sense?

tush — Fri, 15 Mar 2019 11:35:55 GMT

Hi,

try it:-

if(sum(value) >= sum(target), red(), green())

Thanks

Tushar

stekol61 — Fri, 15 Mar 2019 14:04:39 GMT

Hi!

I tried this but it turns all record to Red.

I QV I use this expression, but I can't get it to work in Sense

If ($(v_DS_4G) < If(Len(Only(Country))>0,

num(Only( {$<kpi_item = {'ds_4g'}>}value/1000),'# ##0,00'))

,v_rgb_red, v_rgb_green)

'kpi_item 'and 'ds_4g' are from the loaded target file

jobsonkjoseph — Fri, 15 Mar 2019 14:08:42 GMT

Hi, try this

If ($(v_DS_4G) < If(Len(Only(Country))>0, num(Only( {$}value/1000),'# ##0,00')) ,red(),green())

stekol61 — Fri, 15 Mar 2019 14:45:06 GMT

Hi!

Still not working.

I used my QV expression (kpi) in a table and replaced color with '1' or '0' and this seems to work. see below