topic Re: Highlight` in QlikView

Highlight`

Thu, 20 Mar 2014 11:08:24 GMT

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 — Thu, 20 Mar 2014 11:11:02 GMT

try like this

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

its_anandrjs — Thu, 20 Mar 2014 11:15:35 GMT

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

Thu, 20 Mar 2014 11:15:59 GMT

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 — Thu, 20 Mar 2014 11:17:17 GMT

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

example:

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