Discussion Board for collaboration on QlikView Layout & Visualizations.
After moving one dimension to horizontal axis in pivot table, vertical dimensions background color change is not working any more.
If I move the dimension back to vertical position coloring is working well.
I have the following code in Background color:
=If(ELEMENT_UPDATED > Today()-30 ,RGB(255, 255, 0))
Any idea what is wrong with this one?
Perhaps it could be because you don't have aggregation on ELEMENT_UPDATED and pultiple value for your dimensions. Can you try to add max(ELEMENT_UPDATED ) or mode(ELEMENT_UPDATED ) ?
Share example with us could be great too.
I tried both but they didn't help.
Any other things in mind that I can try?
finally I get back to this issue.
Here is an example. The only difference between those two tables is that I have dragged Area dimension on horizontal axis.
In Pivot Table 1 the colors are as they shoud be.
It's because they have missing values in the first column of the expression (Area1). Unfortunately this leaves the background color blank
Do you know any workaround for this?
Unfortunately no, unless you introduce a bogus 0 value or similar for the missing values in the first column
Thanks for you help, I will try that