Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Color by Expression

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.

14 Replies
akpofureenughwu
Creator III
Creator III

Yeah. They are Treemap

How can I make those color adjustments?

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

Uday_Pasupuleti
Partner - Creator III
Partner - Creator III

Hi,

What are your dim and measures here?

akpofureenughwu
Creator III
Creator III

Can u send me your email so I will send your the app privately.

akpofureenughwu
Creator III
Creator III

Dimensions

=if(match([Newunits],'CRU','VDU-1','FCCU','SRU','KHU','LPG MEROX','GCU','NHU','CDU-2','CDU-1'), [Newunits])

and

Measures

=sum([Remark No])

These are the dim and measures.

Should send you the apps?!

Uday_Pasupuleti
Partner - Creator III
Partner - Creator III

Please post your app.

I'll give it a shot. Not sure but I'll try.

Thanks,