topic Re: Color header in pivot table in QlikView

Color header in pivot table

inescastelhano — Tue, 29 Mar 2016 14:08:18 GMT

Hi folks,

I'm trying to color either the header or the entire column (it doesn't really matter), if the weekday is saturday or sunday. I have the following table, and the following table expression:

=(round((hour(sum({<Day=,[Day of the Week]=>}aggr

(max({<Day=,[Day of the Week]=>}

[time1]-[time2])

, [ID])

))*60+minute(sum({<Day=,[Day of the Week]=>}aggr

(max({<Day=,[Day of the Week]=>}

[time1]-[time2])

, [ID])

)))

/count({< Day=,[Day of the Week]=>}

[Day])))

I'm using this expression to try to color the columns, but it's not working:

if(only({<Day=>}[Day of the Week])='sunday',

RGB(0,0,0))

Any help?

Thanks in advance!

Cheers,

Ines

Re: Color header in pivot table

Chanty4u — Tue, 29 Mar 2016 14:14:07 GMT

u can use custom format cell..

there u can give any colur to any cell of ur table.

go o -->view tab---?select --->grid view--->select ur table--->right clik---->select ur cell and give colur

Re: Color header in pivot table

inescastelhano — Tue, 29 Mar 2016 14:28:14 GMT

Hi, Actually not, because with custom format cell, conditional formatting is not possible.

Thanks

Re: Color header in pivot table

Tue, 29 Mar 2016 16:39:32 GMT

Hi,

Can you try following expression in background color

if(Match(Only(total<Day>[Day of the Week]),'sunday','saturday'),RGB(0,0,0))

Regards,

Nandkishor Pandirkar

Re: Color header in pivot table

inescastelhano — Tue, 29 Mar 2016 16:47:13 GMT

Hi!

Thanks for your reply, but it doesn't work

Cheers,

Ines

Re: Color header in pivot table

Tue, 29 Mar 2016 16:53:34 GMT

Can you attach sample qvw