topic Mapping Color Code in QlikView

Mapping Color Code

Thu, 23 Jul 2015 05:21:13 GMT

Hi,

Below are the details and the required output.

P_color_code is the color code of each project. P_name is the project associated with it.

Level1 is the list of all projects that are in P_name and there are few other.

When i select from Level1 the color disappears this is bcoz of association that has not happened with Level1.

Please help me how to create a new Color_code for Level1.

Please find the attached Qvw.

Thanks,

Keerthi KS

Re: Mapping Color Code

Kushal_Chawda — Thu, 23 Jul 2015 05:45:36 GMT

Put below condition in background colour of P_name

=only({1}P_Color_Code)

Re: Mapping Color Code

Thu, 23 Jul 2015 05:51:25 GMT

This works for P_name.

But i need to join P_color_code for Level1.

Level1 has different data along with P_name data.

Re: Mapping Color Code

jagan — Thu, 23 Jul 2015 06:01:34 GMT

Hi,

I checked your datamodel there are some rows with empty color codes. Split that into tables.

Projects:

LOAD

uniqueid as P_ID,

state as P_State,

name as P_Name,

if(Len(launchdat2)=0,Date($(vDateMin)),

Date(Floor(Num(launchdat2)))

) as P_Date,

Date(if(len(validtill)=0,Today())) as P_Valid_Date,

if(IsNum(code),Num(code),code) as P_Code,

if(IsNum(code),Num(code),code) as PROJECTID,

colorcode as P_Color_Code2,

projectlogo as P_Logo,

shortname as P_Short_Name,

//commonpricebook as CPB_ID,

city as City,

zone as Zone,

pincode as Pincode,

country as Country,

launchdat2 as Launch_Date

FROM

[$(vPath)\teproject.qvd]

(qvd)

ColorCodes:

LOAD

WHERE Len(Trim(P_Color_Code)) > 0;

LOAD

P_Name,

RGB(

16 * Match(Upper(Mid(Replace(colorcode,'#',''),1,1)), $(vHexDigits))

+ Match(Upper(Mid(Replace(colorcode,'#',''),2,1)), $(vHexDigits)),

16 * Match(Upper(Mid(Replace(colorcode,'#',''),3,1)), $(vHexDigits))

+ Match(Upper(Mid(Replace(colorcode,'#',''),4,1)), $(vHexDigits)),

16 * Match(Upper(Mid(Replace(colorcode,'#',''),5,1)), $(vHexDigits))

+ Match(Upper(Mid(Replace(colorcode,'#',''),6,1)), $(vHexDigits))

) AS P_Color_Code

FROM

[$(vPath)\teproject.qvd]

(qvd);

HOpe this helps you.

Regards,

Jagan.

Re: Mapping Color Code

Thu, 23 Jul 2015 06:23:21 GMT

HI Jagan,

Separated the tables. But this ended up with some data error.

How to create separate color_code for Level1. Level1 has many elements including P_name elements. Color_code only for Level1

Regards,

Keerthi KS