topic Re: Visual Cues in QlikView

Visual Cues

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

I have some data within a table..

Is it possible to highlight all the months previous to the current month in red? For example January to May all need to be in red..

Thanks

Mel

m_woolf — Mon, 20 Jun 2016 16:38:13 GMT

In Chart Properties, click the + in front of your Month dimension and double-click on Background Color.

Enter something like:

if(YourMonthField<Month(Today()),red())

You can substitute rgb(xxx,xxx,xxx) for red() if you want more precise control over the color.

krishnacbe — Mon, 20 Jun 2016 16:38:20 GMT

Try to write a expression to color as below

if(Month(Date)< month(Today(), red(),Green())

Anonymous — Tue, 21 Jun 2016 16:05:40 GMT

Awesome! Thanks very much