Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
craig157
Contributor

Listbox Colours on Access Point - Qlikview

Hi All,

I've altered my Listbox default colours in Qlikview so that it's gray, dark gray font & highlight colour of bright pink to fit the marketing specifications.

Unfortunately when I go onto access point it's pulling through the colours from another project (set up a previous employee) and I can't seem to find how to amend this.

 

I am just using the simple macro to update the colours (in edit module):

example:

UserPrefs.CustomSelBgColor(1).PrimaryCol.Col = _

RGB(204,45,111)

Qlikview x64: How it should look and does look on the Qlikview Application.Qlik Listbox Colour Issue - Qlikview Application.jpgWhat is looks like on AccessPoint:

 

 

Qlik Listbox Colour Issue - Qlikview Access Point.jpg

 

 

Any advice would be great! Thanks

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Listbox Colours on Access Point - Qlikview

AFAIK those settings will be stored within the settings.ini - with the macro you set them for your local user but you couldn't do it for the server in the same way else you need to stop your server and adjust the settings.ini manually. You should make a BACKUP before you changed anything.

- Marcus

4 Replies
MVP & Luminary
MVP & Luminary

Re: Listbox Colours on Access Point - Qlikview

AFAIK those settings will be stored within the settings.ini - with the macro you set them for your local user but you couldn't do it for the server in the same way else you need to stop your server and adjust the settings.ini manually. You should make a BACKUP before you changed anything.

- Marcus

craig157
Contributor

Re: Listbox Colours on Access Point - Qlikview

Thanks Marcus. Weirdly the CustSel Colors do not match what we currently have running.

 

SetColorPrefs Macro:

sub SetColorPrefs()

Dim UserPrefs

set UserPrefs = _
ActiveDocument.GetApplication.GetuserPreferences

' Selected colour
UserPrefs.CustomSelBgColor(1).PrimaryCol.Col = _
RGB (244, 144, 30) 'PulseHighLightColour

UserPrefs.CustomSelFgColor(1).PrimaryCol.Col = _
RGB (255, 255, 255) 'White

'Possible Colour
UserPrefs.CustomSelBgColor(2).PrimaryCol.Col = _
RGB (68, 68, 68) 'PulseWindowColour

UserPrefs.CustomSelFgColor(2).PrimaryCol.Col = _
RGB (255, 255, 255) 'White

' Excluded Colour
UserPrefs.CustomSelBgColor(5).PrimaryCol.Col = _
RGB (68, 68, 68) 'Light Grey

UserPrefs.CustomSelFgColor(5).PrimaryCol.Col = _
RGB (87, 87, 87) 'Black

' Locked Colour
UserPrefs.CustomSelBgColor(0).PrimaryCol.Col = _
RGB (255, 0, 0) 'Red

UserPrefs.CustomSelBgColor(0).PrimaryCol.Col = _
RGB (0, 0, 0) 'Black

ActiveDocument.GetApplication.SetUserPreferences _
UserPrefs
end sub

 

 

 

From the Settings.ini file:

CustSelFgColors0=65535
CustSelBgColors0=0
CustSelFgColors1=16777215
CustSelBgColors1=2003188
CustSelFgColors2=16777215
CustSelBgColors2=4473924
CustSelFgColors3=0
CustSelBgColors3=255
CustSelFgColors4=0
CustSelBgColors4=16777215
CustSelFgColors5=5723991
CustSelBgColors5=4473924
CustSelFgColors6=14211288
CustSelBgColors6=8421504
CustSelFgColors7=14211288
CustSelBgColors7=8421504

 

MVP & Luminary
MVP & Luminary

Re: Listbox Colours on Access Point - Qlikview

It's only a different notation of the used colors. To get more background to it and to find the corresponding rgb() respectively the reversed way, take a look here: Colors-in-Qlik.

- Marcus

craig157
Contributor

Re: Listbox Colours on Access Point - Qlikview

Brilliant - not used Decimal for Colour assignment before.

Found from your article it's an RGB to VB Decimal Colour Converting.

https://convertingcolors.com/

Decent converter attached to go along with your QVW:

https://convertingcolors.com/

 

Thanks again Marcus!