topic Re: Background Colour for expression in QlikView

Background Colour for expression

Tue, 31 Jul 2012 13:25:54 GMT

Hi,

I've a table like show below:

Column1	Column2	Column3	value
A	1		10
A	2	1	10
A	3		10
A	4		10
B	1		12
B	2		12
B	3		12
B	4	1	12
C	1		13
C	2		13
C	3	1	13
C	4		13

- I want to display in pivot table with col1 & Col2 as dimension and in expression as background color as red when col3 is 1 and Max of Value column. But this chart should be static, no filters should effect this chart.

As shown below please help me:

Re: Background Colour for expression

MayilVahanan — Tue, 31 Jul 2012 13:38:43 GMT

Try like this,

if(rank(Max({1}Value),Col1) and Col3 = 1, Red(),Green()) use in text color in expression tab "+" sign

and use Max({1}Value) as expression or use {1} in ur expression..

Hope it helps

Re: Background Colour for expression

Tue, 31 Jul 2012 13:44:37 GMT

or try

if(value = Max({1<Column3={1}>}total value) and Column3=1 , lightred(), lightgreen())

as background expression

Re: Background Colour for expression

Tue, 31 Jul 2012 14:03:25 GMT

Hi,

Thanks a lot. But i'm not able to change the concept into my application. Please see this application.

In my application where ColorFlag is 1 and Max(Date) i want to display in 3 expressions as Dia,power,Temp as red color, if it not satisify the condition it should show green color with same names. I need background colour not text colour.expression header should be in plain not should be in colour.

Re: Background Colour for expression

Tue, 31 Jul 2012 14:21:56 GMT

Hi,

As shown in below image for selection. Here i've selected AnoPLDate as 6(i.e i've generated autonumber for each date, instead of date i'm taking autonumber later i'll take date column). For our reference i've selected 6(i.e Feb 06).

- as shown in above image selections what i did. i need in pivot table as below image.

Re: Background Colour for expression

Tue, 31 Jul 2012 15:14:28 GMT

Can anyone help on this. I'm getting mad here to achive this. It is very urgent for me.

Re: Background Colour for expression

MayilVahanan — Tue, 31 Jul 2012 15:34:36 GMT

Use like this,

For 1st-> if(rank(Only({<v1={'Dia'}>}v1)) and ColurFlag = 1, Red(),Green())

For 2nd -> if(rank(Only({<v1={'Power'}>}v1)) and ColurFlag = 1, Red(),Green())

For 3rd-> if(rank(Only({<v1={'Temp'}>}v1)) and ColurFlag = 1, Red(),Green())

Hope it helps

Re: Background Colour for expression

Tue, 31 Jul 2012 16:07:54 GMT

No use. Please try in my application.

Re: Background Colour for expression

MayilVahanan — Tue, 31 Jul 2012 16:30:56 GMT

check this,