topic ARGB Codes in QlikView

ARGB Codes

ZoeM — Sat, 16 Nov 2024 19:28:44 GMT

Community,

Is there an easy way to find out ARGB codes?

I am looking for a green to yellow gradient, and I can use two color gradient for this because its in a pivot chart.

Thanks,

Re: ARGB Codes

albertovarela — Wed, 11 Dec 2019 17:56:22 GMT

You could use http://colorbrewer2.org/#type=sequential&scheme=YlGn&n=3 to get the RGB values then you can play with the Transparency (A) value in the range 0 - 255. 0 corresponds to full transparency and 255 corresponds to full opacity.

Re: ARGB Codes

ZoeM — Wed, 11 Dec 2019 18:05:20 GMT

You learn something new everyday Alberto, Thanks.

But I guess I am not getting the same depth as I was looking for. I thought using ARGB would make it more gradient like, so a gradual rise from Yellow to Green?

Re: ARGB Codes

mrtinsjoao — Wed, 11 Dec 2019 18:05:54 GMT

To discover some color that you want. Use the button "printscrenn" after that, just paste on Paint. Use the

"color selector" select what color you want to know, after "Edit Colors" on "tools bar" and catch the RGB number.

Thanks

João Martins

Re: ARGB Codes

ZoeM — Wed, 11 Dec 2019 18:21:13 GMT

Neat trick there Joao, never knew the painter had that functionality.

Unfortunately when I selected since it was a gradient, it only selected the primary color. But I love that trick though...

Re: ARGB Codes

rwunderlich — Wed, 11 Dec 2019 23:29:57 GMT

A couple of tips:

1. In the QlikView color dialog, you can play with the color picker and note the RGB values.

2. A favorite site of mine for choosing colors, gradients and complements is http://www.html-color-names.com/color-chart.php. Some values on the site are shown only in hex but you can convert to rgb using a tool like here https://www.rapidtables.com/convert/color/hex-to-rgb.html

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: ARGB Codes

ZoeM — Thu, 12 Dec 2019 11:34:25 GMT

Thanks Rob, always valuable input!

Re: ARGB Codes

johnca — Thu, 12 Dec 2019 19:36:59 GMT

You can always alter an A value to make the color less opaque.

My preference when making gradients from one color to another is http://www.perbang.dk/rgbgradient/

Enter the two colors you want, how many steps, and voila!

HTH,

John

Re: ARGB Codes

ZoeM — Fri, 13 Dec 2019 13:34:57 GMT

Thanks John!

Thats a nifty tool to play with.

Re: ARGB Codes

johnca — Fri, 13 Dec 2019 15:04:08 GMT

BTW, I use this expression in a pivot table to make a two color gradient with RGB. I suppose it could be modified to create an ARGB color as well. Note the center color is static at 255 (Green). Varying the Red and Blue makes this one go from white to Green based on the value of Sum(DataValue).

rgb(255-log(1+Sum(DataValue))*50,255,255-log(1+Sum(DataValue))*50)

I believe I found it in one of John Witherspoon's posts many years ago.

I also use this as the text color to make it lighter or darker between white and black.

rgb( 255-log(1+Sum(DataValue))*50, 255-log(1+Sum(DataValue))*50, 255-log(1+Sum(DataValue))*50)

HTH,

John

Re: ARGB Codes

Brett_Bleess — Wed, 18 Dec 2019 16:43:01 GMT

Zoe, just wanted to drop a note to remind you to use the Accept as Solution on the post(s) that helped you with things, you can do multiple solutions if you want just FYI, you have quite a few, but you may want to stick to the ones that were the most relevant for what you needed in this case.

Lastly, I am just going to paste a Design Blog post I found, not sure if it will be of much help or not, but figured it was worth putting in here for others that come by:

https://community.qlik.com/t5/Qlik-Design-Blog/Using-RGB-and-ARGB-to-define-colors/ba-p/1464387

https://community.qlik.com/t5/Qlik-Design-Blog/Colors-in-charts/ba-p/1475280

If you want to do some further searching, you can use the following link to do that:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

Re: ARGB Codes

ZoeM — Wed, 18 Dec 2019 17:25:10 GMT

Thanks Brett.

yes it’s always good to mark what has helped.

thanks as well for the design blog it will prove helpful