topic Re: Variables to set colors for staright table object in QlikView

Variables to set colors for staright table object

Anonymous — Mon, 15 Jun 2015 16:30:23 GMT

Hello,

I am new to QlikView, I need some help in using variables to set color for straight table objects . My requirement in detail is, my report has multiple straight table objects which are categorized into two groups for example lets say out of four objects two objects have data related to source A and the remaining objects have data related to source B. I want all objects with source A to be in one color and the objects related to source B in another color and I wanted to achieve this using a variable . I would really appreciate if some one can help me on this.

Thanks....

Re: Variables to set colors for staright table object

Anonymous — Tue, 16 Jun 2015 07:35:03 GMT

What's the logic for data from sourceA and SourceB ?

Post yoursample data .

Re: Variables to set colors for staright table object

Tue, 16 Jun 2015 07:35:34 GMT

create 2 new variables:

varsoucA=RGB(xx,xx,xx) and

varsourB=RGB(yy,yy,yy)

you need to set this variable say fro table from source A .

custom format cell-backgroundcolor-(using calculated-use varsoucA)

select all dimensions and expressions in apply change to field.

after this u can use format painter on all tables with source A.

similarly for table from source B .-set backgound color as varsourB.

after this u can use format painter on all tables with source B.

Thanks...

Re: Variables to set colors for staright table object

Anonymous — Tue, 16 Jun 2015 14:04:53 GMT

Thanks Kushboo. It worked.