Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

elaineng
New Contributor

Background color for column dimension in pivot table not different in client & access point

 

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.

qlikview_app.jpgQlikview Client

 

However, when I view the dashboard in access point. The column (Type & Project) has no color.Qlikview_web.jpgQlikview Access Point - Web

 

Same issue when I export to excel from access point. Export from client has no issue.Qlikview_excel.pngQlikview export to excel

How can I resolve this issue?

5 Replies
avneet85
Contributor II

Re: Background color for column dimension in pivot table not different in client & access point

Hi,

How the color definition done in Pivot table ?

 

elaineng
New Contributor

Re: Background color for column dimension in pivot table not different in client & access point

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)))

Support
Support

Re: Background color for column dimension in pivot table not different in client & access point

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

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
elaineng
New Contributor

Re: Background color for column dimension in pivot table not different in client & access point

Hi BrettBless, 

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.

Support
Support

Re: Background color for column dimension in pivot table not different in client & access point

Hey Elaine, I think I would go ahead and open a support case, we'll need a copy of the app when you do that, so we can test things for you to see if we can replicate etc., as if we can, we can definitely submit things to the engineers at that point.  Glad you are on the latest SR too, if there is a problem and the engineers are willing to do a fix, that is the release it would go to as a patch etc...  Sorry I do not have anything better for you, the only thing of which I can think is there may be something wrong in a JavaScript somewhere would be my best hunch as to root cause.  We can test in the latest 12.40 SR1 release to see if things behave the same way there etc., that should help narrow things down pretty quickly.  If you do create the support case, you can definitely add this Community post thread link to the case as well as further information for the techs to check out.  

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.  

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.