topic Re: color on cell in QlikView

color on cell

capriconuser — Fri, 06 Apr 2018 11:53:44 GMT

i have table like this

e.g.

employeename dates 20/3/2017 21/3/2017 22/3/2017 23/3/2017

abc employee 5:00 5:00 5:00 -

defemployee - 5:00 5:00 -

xyz employee 5:00 - 5:00 -

now here i want to try if all employees has '-' on then want to color beacuse on 23 suppose to be official holiday

this is i try but not works ..

=if(count({<AbsentFlag = {'Absent'}>}ZID) = $(vTotalEmp),RGB(0,0,255))

this fill cells where they found absent where as i want when all employees have absent then want to color on that specific date not all dates

Re: color on cell

capriconuser — Sat, 07 Apr 2018 12:36:57 GMT

any updated please?

Re: color on cell

vishsaggi — Sat, 07 Apr 2018 13:01:08 GMT

Can you share your sample app where you trying this expression?

Re: color on cell

Anil_Babu_Samineni — Sat, 07 Apr 2018 14:55:59 GMT

Create one field in Script

If(Len(Measure)>0, 'Present' , 'Absent') as Color_Flag

And use this?

=if(count({<Color_Flag = {'Absent'}>} ZID) = $(vTotalEmp),RGB(0,0,255))

Re: color on cell

petter — Sun, 08 Apr 2018 08:12:13 GMT

This should work for you using a Pivot Table:

Re: color on cell

palanimurugan — Sun, 08 Apr 2018 12:54:08 GMT

Hi..

There are 2 ways we can change the color.

1. You can set the color using visual Cues Option. Please refer the snapshot.

2. Goto View---> design gord--> right click on your desired cell-->select custom format cell --->then select the color

Re: color on cell

capriconuser — Mon, 09 Apr 2018 05:38:06 GMT

@petter-s yes this is i have sample data but here i only want red color on 23 .3.2017 like when all are absent then want to red else blue ... beacuse in other columns some are absent and some are present ..

Re: color on cell

vishsaggi — Mon, 09 Apr 2018 15:00:12 GMT

Try this in your background expression like :

extending peters script

Load this.

ColorCode:
CrossTable(Date, Values, 1)
LOAD * INLINE [
employeename,20/3/2017,21/3/2017,22/3/2017,23/3/2017
abcemployee,5:00,5:00,5:00,-
defemployee,-,5:00,5:00,-
xyzemployee,5:00,-,5:00,-
];

Pivot table

Dim: Employeename, Date

Expr: Values

Background expr for Values like below

Re: color on cell

capriconuser — Tue, 10 Apr 2018 06:08:49 GMT

what is expression ?? if i am not wrong i did not see any expression

Re: color on cell

capriconuser — Thu, 12 Apr 2018 05:46:07 GMT

any update

Re: color on cell

vishsaggi — Thu, 12 Apr 2018 13:55:18 GMT

IF you scroll to the right on my earlier reply you can see the expression I used. I sent you a snapshot.

Scroll to the right you can see the expression.