topic Re: Color - Dimensions in QlikView

Color - Dimensions

Mon, 20 Jul 2015 10:09:14 GMT

Hi Experts,

I have a requirement to color like below

For Dim:

Test-Dim1

100

200

300

Here I have to change colors for Test-Dim1 like Test-Dim1(For Test- green, Dim1-Red), How to do that

Re: Color - Dimensions

sunny_talwar — Mon, 20 Jul 2015 10:15:25 GMT

Not entirely clear what your requirement is. Would you be able to elaborate a little?

Re: Color - Dimensions

stigchel — Mon, 20 Jul 2015 10:17:15 GMT

Not sure what is what here, are Test and Dim1 both dimensions? You can use the background color option of the dimension (click on the plus sign in front to expand) and use a color expression. The rowno expression in the example is for excluding the total

Re: Color - Dimensions

Mon, 20 Jul 2015 11:35:05 GMT

My requirement is:

Dimension or Column name - Test-Dim1

and I have to add color for Test-Dim1 as Test is one color and Dim1 is another color for the same column(Test-Dim1)

Re: Color - Dimensions

stigchel — Mon, 20 Jul 2015 11:50:19 GMT

You can use something like the following color expression as explained in my previous post

If([Test-Dim1]='Test',Green(),if([Test-Dim1]='Dim1',Red()))

Re: Color - Dimensions

Mon, 20 Jul 2015 12:15:49 GMT

My requirement is:

Dimension or Column name - Test-Dim1

and I have to add color for Test-Dim1 as Test is one color and Dim1 is another color for the same column(Test-Dim1)

Column name: Test-Dim1(Full name of Column name)

and in that Test is one color and Dim1 is another color

Re: Color - Dimensions

stigchel — Mon, 20 Jul 2015 12:32:47 GMT

Yes, what is the problem? The expression from my previous post should do that, use that in the background color of the dimension as you can see in my screen shot. Or do you want this color in a listbox? then see this example:

Listbox Color Chips | Qlikview Cookbook

Re: Color - Dimensions

Mon, 20 Jul 2015 13:24:07 GMT

No need to effect values. It just for Name of the field..

In the same field name need to colors

For ex name of the column: ABC. A is one color and B is another color

Re: Color - Dimensions

stigchel — Mon, 20 Jul 2015 13:37:10 GMT

So you want the label of the header/column name in two colors? That is not possible, you can for example use Test as label and make it green, and position a text box on top with Dim1 in red.

Re: Color - Dimensions

Mon, 20 Jul 2015 13:39:23 GMT

if(SubField('Test-Dim1','-',1),green(),red())