Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
add the the first condition to check for TOTAL Column
if(Columnno()=0 , black() , you next conditions in the Text Color Expression.....................)
Use the SecondaryDimensionality() function to check if you're on the detail or the total level
If(SecondaryDimensionality()=0, ...color-expression... )
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))
thanks.bt i need to change only text color of the total not the background color
add the the first condition to check for TOTAL Column
if(Columnno()=0 , black() , you next conditions in the Text Color Expression.....................)
Thanks Vineeth
Its worked.thank u so much
Glad to hear that, please close this thread
Qlik Community Tip: Marking Replies as Correct or Helpful