topic Re: Color Help in QlikView

Color Help

sundarakumar — Fri, 17 Jul 2015 07:40:33 GMT

Hi All,

My requirement is to set the background color in a straight table. The background of the Dimenison or expression to be set with the RGB of the dimension itself.

Attached a sample app.

Creating a nested if is impossible since expecting lot of more entries.

Thanks is advance.

-Sundar

Re: Color Help

Kushal_Chawda — Fri, 17 Jul 2015 07:47:03 GMT

How you gonna set the background color? is it based on some condition?

Re: Color Help

Anonymous — Fri, 17 Jul 2015 07:47:39 GMT

whey you click on the "#" sign at Dimension or Expression you

may define the textcolor to your likings

e.g. Expression textcolor rgb(255,128,128)

Re: Color Help

sundarakumar — Fri, 17 Jul 2015 07:50:57 GMT

the dimension is iteself the color. I just want to set the dimension as the background color.

eg. 1st row - black, 2nd row - blue, thrid row - yellow, like wise...

I want the color of background to be dynamic in accordance with the dimension.

-Sundar

Re: Color Help

sundarakumar — Fri, 17 Jul 2015 07:52:10 GMT

The text color or back ground color needs to be dynamic in accordance with the dimension.

Please refer to the attached sample app.

Re: Color Help

Anonymous — Fri, 17 Jul 2015 07:58:04 GMT

I donot see your attached app

what I did for a customer with a small masterdata Dimension (about 20 values)

I used an inline code where I attached for each value an own colour (rgb code)

then joined it to Dimension and thenI could use the colorfield in the Background Color field

I have no clue how to give each row another color

Re: Color Help

sundarakumar — Fri, 17 Jul 2015 08:02:17 GMT

Sorry, my bad. Attached the app now. Please check , Am trying to replicate the same here, but looks like am missing something.

Please help.

-Sundar

Re: Color Help

Fri, 17 Jul 2015 08:18:36 GMT

There should be some other way. Working on that. Mean while below works for time being.

=RGB(SubField(KeepChar(RGB,'123456789,'),',',1),

SubField(KeepChar(RGB,'123456789,'),',',2),

SubField(KeepChar(RGB,'123456789,'),',',3))

Regards,

KKR

Re: Color Help

sundarakumar — Fri, 17 Jul 2015 08:27:25 GMT

Great Works like heaven Thanks a lot

-Sundar

Re: Color Help

sundarakumar — Fri, 17 Jul 2015 08:37:33 GMT

Hi,

Need a 0 to be added to the string '1234456789,'.

Used an alternative shown below

Thanks again for the help

RGB(SubField(mid([Decimal Code(R,G,B)],2,len([Decimal Code(R,G,B)])-2),',',1),
SubField(mid([Decimal Code(R,G,B)],2,len([Decimal Code(R,G,B)])-2),',',2),
SubField(mid([Decimal Code(R,G,B)],2,len([Decimal Code(R,G,B)])-2),',',3))

-Sundar

Re: Color Help

Fri, 17 Jul 2015 08:50:17 GMT

Though I missed 0, RGB() function replaces NULL with 0. So it worked. Good eye Sundarakumar‌

Regards,

KKR

Re: Color Help

sundarakumar — Fri, 17 Jul 2015 08:51:27 GMT