Highlight`

[#1]

HI all,

I got this pivot table:

The actuals of 2011 also show month 1-12. Now I wonder if it's possible to let qlikview highlight the last 12 months.

So if my years would be 2013-2014 it would highlight(different colour) 2013 month 3 uptill month 3 2014.

Maybe there is some way to get this done but im pretty clueless.

kind regards

[jsingh71]

try like this

If(Year='2012', Green())

[its_anandrjs]

Hi,

In Background option by click on + sign apply value like If(Year >= 2013 and Year <= 2014, Blue( ),Green( )) some thing like you have to change.

Thanks & Regards

[#4]

Maybe using a sequential YearMonth field and using something like this in the color properties of the Expression:

IF( YearMonthSeq >= max(YearMonthSeq) - 11, greencolor, white() )

To create this YeatMonthSeq field, multiply the Year by 12 and then sum the Month number:

LOAD

...

Year(Date) * 12 + num(month(Date)) as YearMonthSeq,

...

FROM ...

Hope it helps.

[cgdonders]

Open the dimension properties (+ icon) and change the text and/or background color:

example:

=IF(Month>=MONTH(TODAY()), red(), green() )