topic Re: Colour code the row based on dimension in QlikView

Colour code the row based on dimension

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Is it possible to colour code entire row based on a dimension?

For example:

PolTerm	Qnums	Pnums
Cur	Q1244	P1256
Fut	Q1244	P5645
Cur	Q2345	P556
Fut	Q2345	P5647

Desired result

PolTerm	Qnums	Pnums
Cur	Q1244	P1256
Fut	Q1244	P5645
Cur	Q2345	P556
Fut	Q2345	P5647

Any help would be helpful.

Thanks,

Anupama Jagan

Re: Colour code the row based on dimension

sunny_talwar — Wed, 10 May 2017 17:21:16 GMT

Yes you can, but you will need to right the same expression for each of your dimension and expression's background color expression

Re: Colour code the row based on dimension

Anil_Babu_Samineni — Wed, 10 May 2017 17:23:57 GMT

May be this expression for all BG color expression

=if(Even(RowNo(TOTAL)), rgb(198,224,180), rgb(180,198,231))

Re: Colour code the row based on dimension

Anonymous — Wed, 10 May 2017 17:24:23 GMT

I need this one based on polterm. for cur it should be in one colour and Fut in another colour. so I need to write the same expression on all dimensions and expressions?

Re: Colour code the row based on dimension

sunny_talwar — Wed, 10 May 2017 17:25:52 GMT

Yes... something like this

If(PolTerm = 'Cur', RGB(...),

If(PolTerm = 'Fut', RGB(...)))

Use this as background color expression for all your expressions and dimensions

Re: Colour code the row based on dimension

Anonymous — Wed, 10 May 2017 17:27:56 GMT

But it wont be like this for all records.I just gave as example. it might be like this too

PolTerm	Qnums	Pnums
Cur	Q1244	P1256
Fut	Q1244	P5645
Cur	Q2345	P556
Fut	Q2345	P5647
Fut	Q3435	P987

Basically the colour coding must be on polterm.

Re: Colour code the row based on dimension

Anil_Babu_Samineni — Wed, 10 May 2017 17:32:01 GMT

As Sunny, Mentioned you must use this for all Dim's and Expressions

=If(PolTerm='Cur', rgb(198,224,180), rgb(180,198,231))

Re: Colour code the row based on dimension

Anonymous — Wed, 10 May 2017 19:02:00 GMT

Thanks a lot