color expression

[Anonymous]

Hi,

In this,i dont want the color in the total tab.how can i remove it..if i give the condtion for color expression..total values are also changed..how can i do it..

[Gysbert_Wassenaar]

Use the SecondaryDimensionality() function to check if you're on the detail or the total level

If(SecondaryDimensionality()=0, ...color-expression... )

[shaktisinghchau]

Navigate to following window

Chart/Table Properties -> Expressions Tab - > Total column -> Expand it and click to Background Color

here you can write the expression based on cell value you can change background color of the cell like below

=If( Total >= 10000000, RGB(255,40,0),RGB(255,255,255))

[Anonymous]

thanks.bt i need to change only text color of the total not the background color

[vinieme12 · Accepted solution]

add the the first condition  to check for TOTAL Column

if(Columnno()=0 , black() , you next conditions in the Text Color Expression.....................)

[Anonymous]

Thanks Vineeth

Its worked.thank u so much

[vinieme12]

Glad to hear that, please close this thread

Qlik Community Tip: Marking Replies as Correct or Helpful