Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This?
Expression:
=If(ColumnNo()=0,
If(Year=max(total Year),
If(Sum(Sales) > Sum(Aggr(Above(Sum(Sales)),Customer, Year)), Green(), Red())))
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())
))