Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
israrkhan
Specialist II
Specialist II

Qlikview Default color selection change

Hello Community,

i am changing qlikview default selection color(green to another color) using below macro.

its working fine in desktop,

but its not working in Access point... i am using this macro onopen trigger in Accesspoint.

and i am using qlikview latest version , and IE PLUGIN...

Kindly Help...

Many Thanks...

Sub SetColorPrefs()

Dim UserPrefs

set UserPrefs = _

ActiveDocument.GetApplication.GetUserPreferences

' Set the "Selected" Color

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

RGB (0,0,255) ' Blue

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

RGB (255,255,0) ' Yellow

' Set the "Possible" Color

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

RGB (255,255,0) ' Yellow

UserPrefs.CustomSelFgColor(2).PrimaryCol.Col = _

RGB (0,0,0) ' Black

' Set the Excluded Color

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

RGB (200,200,200) ' Light gray

UserPrefs.CustomSelFgColor(5).PrimaryCol.Col = _

RGB (0,0,0) ' Black

' Set the Locked Color

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

RGB (255,0,0) ' Red

UserPrefs.CustomSelFgColor(0).PrimaryCol.Col = _

RGB (0,0,0) ' Black

ActiveDocument.GetApplication.SetUserPreferences _

UserPrefs

end sub

2 Replies
jsn
Employee
Employee

Hi,

You might want to try this document extension instead:

Document Extension to override green selection color

israrkhan
Specialist II
Specialist II
Author

Thanks For the Reply,

i downloaded and installed this extension, its working fine...

but how to edit colors, because its using blue color as default...

1) how can i add my own color to this extension ?

2) do i need to add this extension to all documents on my server, let say i have 100 documents on server...

do i need to open one by one and go to document properties >> extensions and i have to add extension there??

Many Thanks