topic Re: Color issue??? in QlikView

Color issue???

Wed, 12 Nov 2014 13:39:19 GMT

I have a straight table without dimension and 5 expressions.

Like this

Expr1 200

Expr2 320

Expr3 100

Expr4 120

Expr5 500(not values yellow but back ground color should be blue)

I want a table like this i am using horizontal here.here i need background color Blue for expr5.

Re: Color issue???

Anonymous — Wed, 12 Nov 2014 13:43:51 GMT

Rakesh,

Go to edit background color (expand options in expression Expr5) and type:

=blue()

or also with:

=RGB(0,0,255)

Marc.

Re: Color issue???

Anonymous — Wed, 12 Nov 2014 13:45:43 GMT

Go to Properties --. Visual Cues --> Click on Background which is at Upper >= 500

Re: Color issue???

Wed, 12 Nov 2014 14:08:18 GMT

Hi,

Thanks you but here i want that color for label not for value

Re: Color issue???

Wed, 12 Nov 2014 14:08:26 GMT

Hi,

Thanks you but here i want that color for label not for value

Re: Color issue???

Anonymous — Wed, 12 Nov 2014 14:15:24 GMT

Go to Dimension tab --> Used Dimension --> Expand your Label --> Right click on bBackground color and Edit Expression their provide =blue()

if you need it only for specific row value then

=if(filedname = filed_value, Blue())

Re: Color issue???

Wed, 12 Nov 2014 14:17:14 GMT

not possible in qlikview

Re: Color issue???

stigchel — Wed, 12 Nov 2014 14:39:17 GMT

See attached, using a calculated dimension as header

Re: Color issue???

Wed, 12 Nov 2014 14:41:39 GMT

Hi,

But here i don't have dimensions but i have expressions.how we can change the baclground color for the expression.

Re: Color issue???

Anonymous — Wed, 12 Nov 2014 14:45:36 GMT

Can you send screen shot of the stright table

Re: Color issue???

Wed, 12 Nov 2014 15:10:54 GMT

Hi,

It is not possible in qlikview. by using the custom format cell then it will reflect the all the expressions but not for any single expression.