topic Re: Highlight Cells That are Below a Certain Amount in QlikView

Highlight Cells That are Below a Certain Amount

oliveton — Sat, 16 Nov 2024 01:24:05 GMT

I'm trying to highlight the background color red for the top worst 20 sales and my expression is not working.

I have the below entered.

if(BISalesResultSummed <= '-10398.45', RED(), Black())

This results in creating another column with RGB(0,0,0) listed in each cell.

How do I highlight my background for these 22 or so numbers?

Thanks

Re: Highlight Cells That are Below a Certain Amount

Rodj — Tue, 28 Jan 2020 22:31:50 GMT

Are you using QlikView or Qlik Sense? Your post is tagged as QlikView but as it isn't in the QlikView forum I'm just confirming. Either way, can you provide a screenshot of where you've entered your formula? It sounds as though you are entering it as a measure rather than as a property of the measure that I presume is called BISalesResultSummed.

Cheers,

Rod

Re: Highlight Cells That are Below a Certain Amount

oliveton — Wed, 29 Jan 2020 12:46:47 GMT

I'm using Qlikview.

Please see my expression attached below.

Thanks !

Re: Highlight Cells That are Below a Certain Amount

Kushal_Chawda — Wed, 29 Jan 2020 13:02:39 GMT

I think you are creating separate expression which is wrong. Click '+' sign of the actual expression, in back ground color put that color expression.

Re: Highlight Cells That are Below a Certain Amount

oliveton — Wed, 29 Jan 2020 14:15:41 GMT

I see now, got it. Thanks !