I've deployed a dashboard in with Qlikview client which contains a pivot table with column dimension (Type, Project) as per image below. The dimension background color is highlighted in light orange as per below.
However, when I view the dashboard in access point. The column (Type & Project) has no color.
Same issue when I export to excel from access point. Export from client has no issue.
How can I resolve this issue?
In the row dimension, I have any row called color code which determines the row color. The code as below:
=IF(ColorCode = 1, RGB (252, 228,214), IF(ColorCode = 2 , RGB (191,191,191)))
For the column dimension, it is determined by the type value. Which the formulas look like:
=IF(Type = 'AFTER MBW AWARD', RGB(153,255,204), if (Type = 'AFTER NSC AWARD', RGB(153,204,255), RGB(255,204,153)))
Elaine, you did not mention which version you are running, that would be useful on this one, but one thing I can suggest just to get some further info would be to try the IE Plugin client from the AccessPoint, if you have the Desktop Client installed on your machine, you have the IE Plugin client, just use Internet Explorer as the web browser, and you should be able to then use the View Details link on the app thumbnail to choose the Plugin client instead of the Ajax client, I am curious if the Plugin works like the Desktop, as if it does, that would seem to indicate a potential defect in the server-side functionality for the Ajax client, and the best thing would be to open a support case, but depending upon the version you are running, there may be a newer SR you can try to see if things work there etc...
The latest releases for the supported versions are:
11.20 SR19 11.20.13804
12.10 SR11 12.10.20900
12.20 SR9 12.20.21000
12.30 SR3 12.30.20300
12.40 SR1 12.40.20100
I am using 11.20 SR19 11.20.13804
I never use IE plugin as it leads to another problem. We used AD to login Qlikview access point, when login password contains special character, it will never able to login from IE successfully. Other browser has not issue.
The only other thing I could offer is if you want to send me the app or a FTP link or something, you could do that as a private message if you want, and I can test things for you on my side to see what I see, and I can post things back here as to results.