topic Calculated colors in caption in QlikView

Calculated colors in caption

Mon, 28 Jun 2010 06:46:36 GMT

Can anyone help me out because i have this field that has three values and i want all caption to change colors for each value that they pick in the field but i cant seem to find the right formula because the normal if is only good for 2 colors like

if(GetFieldSelections([Field]) = 'A',RGB(0,0,0),RGB(255,255,255))

how can i make a three color if statement?

Help would much be apreciated. ;)c

Calculated colors in caption

Mon, 28 Jun 2010 07:59:18 GMT

As far as my understanding of your problem. You can write in this way

if(ID=1,rgb(55,255,255),
if(ID=2,rgb(255,25,205),
if(ID=3,rgb(2,55,255))))

AW:Calculated colors in caption

brenner_martina — Mon, 28 Jun 2010 08:14:56 GMT

Hi,

do you want to find a substring, so could help that function:

index( s1 , s2 [ , n ] )

Position of a substring. This function gives the starting position of the n:th occurrence of substring s2 in string s1. If n is omitted, the first occurrence is assumed. If n is negative, the search is made starting from the end of string s1. The result is an integer. The positions in the string are numbered from 1 and up.

Examples:

index( 'abcdefg', 'cd' ) returns 3

index( 'abcdabcd', 'b', 2 ) returns 6

index( 'abcdabcd', 'b', -2 ) returns 2

left( Date, index( Date,'-') -1 ) where Date = 1997-07-14 returns 1997

mid( Date, index( Date, '-', 2 ) -2, 2 ) where Date = 1997-07-14 returns 07

Hope, that's it!

Calculated colors in caption

Mon, 28 Jun 2010 09:17:06 GMT

Thats it..thanks so much!