topic Color in QlikView

Color

perumal_41 — Wed, 28 Mar 2012 04:02:12 GMT

Dear All,

We have requirement as below

We have a field with some string values eg: Bangalore - India in a table column.

We have to apply different color bangalore and India though it is shown as a single column in a Straight table object.

we have tried several methods but could not get solution for the same.

I hope you would help us in getting the solution.

Note: we should have the data into a single only, should not split to two columns.

Thank you.

sivarajs — Wed, 28 Mar 2012 06:36:36 GMT

Hi,

can you see the attached file

This is what you are trying to do..or..

Sivaraj S

Wed, 28 Mar 2012 06:50:02 GMT

in expression tab put City as field name, then pres + to expand the in click Back ground color

in defination put the expression

=if(Name='Bangalore',Yellow(),LightGreen()).

apply then in straight table you will see Banglore in yellow while rest as light green.

Thanks

Anant

perumal_41 — Wed, 28 Mar 2012 06:53:10 GMT

thanks for ur Replay.but i want output below this style in single coloum on object

Regards

Perumal A