topic Fixed Color Palette in QlikView

Fixed Color Palette

gargi_bardhan — Fri, 17 Feb 2012 12:56:15 GMT

Hi!

Is there any way to fix color palette for an application on document level ?

The problem is as new month starts the application automatically picks random color to display for that particular month,

but I want a color palette pre defined, so that whennever new month arrives, it should pick from the Palette itself.

Regards,

Gargi

Fixed Color Palette

Anonymous — Fri, 17 Feb 2012 13:03:03 GMT

Better, You can set the specific theme for your document.

Regards

Ashok

Fixed Color Palette

CELAMBARASAN — Fri, 17 Feb 2012 13:07:56 GMT

Hi,

Use persistent color option which below the Multicolored option in the properties of the color tab.

This Fixes the color for the Month or year.

Celambarasan

Fixed Color Palette

gargi_bardhan — Sat, 18 Feb 2012 06:28:10 GMT

Hi Celambarasan !

I got your point, let me explain see like in my organization there are some fixed colors, so for example right now its Feb month running, so according to financial year(April-Mar) it's 11, so all reports are showing 11months & colors are fixed for each month by chooisng the way you mentioned, fyn, but as on 1 Mar the qv will randomly pick color to dislplay against Mar, so how could I pre-define the color for Mar ?

So I want a predefined palette which will contain 15-20 Client defined colors, so that whole application automatically picks one of the color out of this Palette only .

Thanx for the quick response.

Regards,

Gargi

Re: Fixed Color Palette

CELAMBARASAN — Mon, 20 Feb 2012 04:36:51 GMT

Hi,

If you have predefine the colors then you have go with the background color option only.

See the attached file in that use the expression below in the definition field

if(DimensionField='Jan',RGB(255,0,0),if(DimensionField='Feb',RGB(0,255,0)))

Hope it helps

Celambarasan

Re: Fixed Color Palette

jagan — Mon, 20 Feb 2012 06:22:10 GMT

Hi,

You can define the predefined mapping table for colors for each month.

Please check the attachment for solution.

Example:

Month Color

Jan-11 RGB(255,0,0)

Feb-11 RGB(250, 0, 0)

Like this define a table with colors.

Note : In the above mapping table give the column name same as you month column name.

Now in the Background color option of expression give

=Color

Now it fills with the predefined background color.

Hope this helps you.

Regards,

Jagan.

Fixed Color Palette

CELAMBARASAN — Mon, 20 Feb 2012 06:47:25 GMT

Hi,

jagan mohan suggestion will be fine for you requirement.

Celambarasan

Fixed Color Palette

gargi_bardhan — Tue, 21 Feb 2012 10:13:38 GMT

Thanks Jagan & Celambarasan !!