topic color expression in QlikView

color expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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..

Re: color expression

Gysbert_Wassenaar — Wed, 21 Dec 2016 09:30:58 GMT

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

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

Re: color expression

shaktisinghchau — Wed, 21 Dec 2016 09:35:10 GMT

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))

Re: color expression

Anonymous — Wed, 21 Dec 2016 09:38:21 GMT

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

Re: color expression

vinieme12 — Wed, 21 Dec 2016 09:45:24 GMT

add the the first condition to check for TOTAL Column

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

Re: color expression

Anonymous — Wed, 21 Dec 2016 10:11:39 GMT

Thanks Vineeth

Its worked.thank u so much

Re: color expression

vinieme12 — Wed, 21 Dec 2016 10:16:34 GMT

Glad to hear that, please close this thread

Qlik Community Tip: Marking Replies as Correct or Helpful