Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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....
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...
What's the logic for data from sourceA and SourceB ?
Post yoursample data .
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...
Thanks Kushboo. It worked.