Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
stekol61
Creator
Creator

Font color in Pivot

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?

4 Replies
tush
Creator II
Creator II

Hi,

     try it:-

 

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

 

 

Thanks

Tushar

stekol61
Creator
Creator
Author

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
Creator III
Creator III

Hi, try this

 

If ($(v_DS_4G) &lt; If(Len(Only(Country))&gt;0, num(Only( {$}value/1000),'# ##0,00')) ,red(),green())

stekol61
Creator
Creator
Author

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 

target.PNG