topic Conditional color for totals in Pivot Table in QlikView

Conditional color for totals in Pivot Table

fheidenstecker — Thu, 04 Aug 2016 14:04:21 GMT

Hello Qlik Comnunity,

i have a question how to conditionally set the color of the totals in a Pivot table. I want to highlight the columns depending if the value is bigger or smaller than last years value.

I was able to access the Column using columnno()=0, and checking the year. But now i am stuck comparing the values for the years.

I attached a sample file....

Can anybody help?

Regards from Germany,
Fabian

Re: Conditional color for totals in Pivot Table

sunny_talwar — Thu, 04 Aug 2016 14:23:28 GMT

This?

Expression:

=If(ColumnNo()=0,

If(Year=max(total Year),

If(Sum(Sales) > Sum(Aggr(Above(Sum(Sales)),Customer, Year)), Green(), Red())))

Re: Conditional color for totals in Pivot Table

vishsaggi — Thu, 04 Aug 2016 20:13:04 GMT

Try this?

= IF(ColumnNo() = 0,

IF(Year = Max(Total Year),

IF( Sum( Total <Customer, Group> {< Year={ $(=max(Year))}>}Sales) > Sum(Total <Customer, Group> {< Year = {$(=Max(Year)-1)} >} Sales), Green(), Red())

))