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

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

elaineng — Wed, 25 Nov 2020 16:16:04 GMT

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 Client

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

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

How can I resolve this issue?

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

New-Qlik — Wed, 20 Nov 2019 12:39:54 GMT

Hi,

How the color definition done in Pivot table ?

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

elaineng — Thu, 21 Nov 2019 01:23:51 GMT

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

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

Brett_Bleess — Wed, 04 Dec 2019 18:40:09 GMT

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

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

elaineng — Thu, 05 Dec 2019 01:13:43 GMT

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.

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

Brett_Bleess — Thu, 05 Dec 2019 14:36:10 GMT

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