topic Re: How To Export Color Scheme? in QlikView

How To Export Color Scheme?

Fri, 16 Sep 2011 17:51:16 GMT

Hello,

I am wondering how I can export my current order of color schemes, so I can use that same order in another QV file?

Your help is appreciated!

How To Export Color Scheme?

Fri, 16 Sep 2011 18:02:54 GMT

Hi,

If the theme allows you to export the color schema, try that way.

Else you create an excel and give name for color value and try to use it different applications by creating variable.

Regards,

Srini.

Re: How To Export Color Scheme?

IAMDV — Fri, 16 Sep 2011 21:49:05 GMT

Hi,

You can use Themes and under chart properties > Colors > Advaned > Advance Color Map.

Here you can set colors palette for specific Sheet, Document & QV User.

Apart from all this... I generally load my colors in the Load Script for re-usability. And I use the HidePrefix setting to hide these columns (Incase, if its causing confusion). This way my colors can be exported to other documents. Also for example if you have 20+ charts in a document and if you have to change the branding for customers, then you might change them in the load script and everything changes in the charts.

I hope this helps!

Cheers - DV

Re: How To Export Color Scheme?

Sun, 18 Sep 2011 04:09:09 GMT

hey Srinivasan,

What do you mean by "Else you create an excel and give name for color value and try to use it different applications by creating variable." ? canyou please elaborate.

Hey D V,

Can you share more information about what kind of load script you use to show same color sheet objects in all Qvw and how do you hide it?? Please.

Thank you.

Regards,

Abha

How To Export Color Scheme?

Thu, 20 Oct 2011 06:45:37 GMT

Hi DV

Can u Provide more info on how to apply color scheme, i have more then 100 Products and i have specified there color in Excel, can u share how to relate all the charts in the QV file such that when ever that product come it take specific color that is mention in the excel

Re: How To Export Color Scheme?

IAMDV — Thu, 20 Oct 2011 08:06:48 GMT

Hi,

Please can you provide Excel file with colors? I will mock up an example for you.

Cheers - DV

Re: How To Export Color Scheme?

Thu, 20 Oct 2011 14:28:48 GMT

HI DV,
PFA excel with the color code of each country

Re: How To Export Color Scheme?

IAMDV — Fri, 21 Oct 2011 09:54:42 GMT

Hi Mohammed,

I am attaching the QV example with your Color values. Will it be okay if I use your Country.Xlsx file for a blog post on this topic? I hope this is what you are looking for...

Let me know if you have any further questions.

I hope this helps!

Cheers - DV

Re: How To Export Color Scheme?

IAMDV — Fri, 21 Oct 2011 09:56:19 GMT

Hi Abha,

Please see the above post. I have answered this question. Sorry for the delay.

Cheers - DV

Re: How To Export Color Scheme?

Fri, 21 Oct 2011 13:24:01 GMT

hi DV,
Yes you can use the color, can u do one more help, i am using Personal Edition of Q.V it would be great of you if you can send it to me in a notepad or reply it

How To Export Color Scheme?

Wed, 02 Nov 2011 13:35:25 GMT

hi DV,
The color scheme is not working; if i take it in the Expression the color is turning to black, can u check it

Re: How To Export Color Scheme?

IAMDV — Thu, 03 Nov 2011 09:38:04 GMT

Hi Mohammeds,

Yes, thats true. When you take the expression out you will loose the colors. Because the colors are part of the expression. You need add click on the sign next to your expression. And you need to use the below expression for Background Expression.

=RGB(Only(R), Only(G), Only(B))

The reason being we wanted the colors for each dimension instead of one color for all the dimensions. I am attaching the image for your reference. I hope this helps!

Good luck!

Cheers - DV

How To Export Color Scheme?

Thu, 17 Nov 2011 11:42:59 GMT

hi DV,

Sorry for the late response was on a short vacation and now its working fine,

i have one more doubt if you can help me it would be great, in my list box of country i have to show only few country names but i have to uploaded color data for all countries by whch the list box of country is getting elabrated, can u tell if its possible that i upload the color data also and its does not affect the list box
thanks in advance

Re: How To Export Color Scheme?

cheburashka — Tue, 19 Mar 2013 16:04:43 GMT

Hi Deepak,

I tried to search your blog "Qlikshare" on the keywords "color" and "color scheme". Didn't find youre example.

Can you give me the name of the blogpost or the exact URL?

,Thx alot

_Koen