Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.What is looks like on AccessPoint:
Any advice would be great! Thanks
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
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
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
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
Brilliant - not used Decimal for Colour assignment before.
Found from your article it's an RGB to VB Decimal Colour Converting.
Decent converter attached to go along with your QVW:
Thanks again Marcus!