Color by Expression

[#1]

Hello Everyone, I need to make some color changes on the scoreboard I designed recently.

I need your help. Please find the attached file for clarity.

[arulsettu]

coloring the sheet name is not possible. other objects are KPI?

[Uday_Pasupuleti]

In 3.0 you can do the sheet title styling.

But for the objects you need to create your own widgets with the required styling.

There are few videos on youtube created by Qlik which gives you an introduction to the widgets.

https://www.youtube.com/watch?v=nBg3E8CCytE

Thanks,

[akpofureenughwu]

arulsettu‌ Thanks for your timely response.

Other objects are KPI. I used a treemap object for the design

Under the appearance/presentation

I need to change the header color to Blue

and change the overlay labels to Red while the area remain white.

I tried using the color by expression: if(Status='SHUTDOWN',lightred(),White ())

but it couldn't display what I wanted.

Can you help?

Thanks in advance

[arulsettu]

can you post your same qvf and with expected output

[akpofureenughwu]

Thanks bro. I'm already downloading 3.0 but can u review the attached file to see how I can do the clor changes. Please find the attached file.

[Uday_Pasupuleti]

HI,

The top one deep lemon you can do straight away.

If your objects are just kpi's then you can use the existing examples of widgets which I think will fill your requirements.

But if they are some different object for the headers and fill colors you need to create the widgets.

Please go through the video which shows you how to build a simple widget and the rest depends on how good you are with html and css.

Thanks,

[Uday_Pasupuleti]

You can get something like this

[akpofureenughwu]

Thanks Uday

I'm on 3.0

How can I achieve these following on 3.0

Please find the attached file.

My skill on HTML or CSS is not quite good.

Any tips on how to improve it.

[Uday_Pasupuleti]

The sheet color green can be done straight away..

But are those objects are KPI's?

Thanks,