topic Re: Label Background Color in QlikView

Label Background Color

bhusjosh — Fri, 14 Dec 2018 09:51:22 GMT

Hello experts,

How to change background color of particular label in QlikView Straight table or Pivot table.

Please find attached file for reference.

Regards,

Bhushan

Re: Label Background Color

uacg0009 — Fri, 14 Dec 2018 10:07:04 GMT

Hi Bhusjosh,
In "View" tab, there is a selection called "Design Grid".
Or you can click "Ctrl + G" to open it.
Then right click the cell of your straight table.
Choose the "Custom Format Cell"
Then change what you want.
Aiolos

Re: Label Background Color

bhusjosh — Fri, 14 Dec 2018 10:15:53 GMT

Hi Aiolos,

Thanks for your response. This solution works for changing all the labels.

I don't want to change all the labels color i want to change few among all (e.g. Column-1 Green, column-2 yellow Column-3 red like this). You can see in attached file.

Regards,

Bhushan

Re: Label Background Color

uacg0009 — Fri, 14 Dec 2018 10:25:55 GMT

if there is logic, you can write some conditions in expression(background part)
In expression tab, click "+" of your expression,
and maybe you can write
if(column() = 1,green(),if(column()=2,blue().....
Please try.
Aiolos