Convert Nested If's to Div: Pivot Table Acting As Heatmap Background Color
The following background color equation for my pivot table works great in the qlikview app, but when posted on the server it flashes and the pivot table object is blank white. I think I am using too many nested if statements for it to work when moved to the server.
Can anyone help me convert the below equation using the Div Function?
It's hard to tell without knowing the context of these expressions.
Note that Avg(DEMAND), Min(DEMAND) and Max(DEMAND) may return the same value, depending on the context of the aggregations (that could explain the difference to your first expression where you were using a TOTAL qualifier in some aggregations).
Debugging kind of these issues is much more easy with a sample provided.
Finally, have you considered using one of the color functions available in Qlik, like ColorMix1()?