Solved: Dimension background color in a pivot table (QV 11... - Qlik Community

iliyansomlev · ‎2014-02-03

Please see the attached example. I want to show Saturdays in light gray and Sundays in gray but it doesn't work. Could you tell me where I make mistake? Thanks!

agilos_mla · ‎2014-02-03

You need to compute the day for the entire column otherwise the pivot will only set color where numbers <> 0 or null.

Use this expression in the background expression (not the dimension background!) (daynum for Monday is 0 in QV)

= if(max(total <DateUse> WeekDay(DateUse))=6,rgb(200,200,200),
if(max(total <DateUse> WeekDay(DateUse))=5,rgb(240,240,240)) )

Michael

View solution in original post

Anonymous · ‎2014-02-03

Lliyan

Try this for the background colour on your Dimension.

=if(WeekDay='Sun',rgb(200,200,200),if(WeekDay='Sat',rgb(240,240,240)) )

Best Regards, Bill

iliyansomlev · ‎2014-02-03

I have tried, it doesn't work

Clever_Anjos · ‎2014-02-03

Use this expression as Background color for your Dimension

=if(WeekDay(DateUse)='Sun',rgb(200,200,200),if(WeekDay(DateUse)='Sat',rgb(240,240,240)))

Aurelien_Martinez · ‎2014-02-03

Hi,

You can use this expression for your background color :

=pick(Match(WeekDay(DateUse), 'Sun', 'Sat'), rgb(200,200,200), rgb(240,240,240))

Best,

Aurélien

Help users find answers! Don't forget to mark a solution that worked for you!

Report Inappropriate Content · ‎2014-02-03

Did you try with colour functions Light Gray & Dark Gray (using these in IF condition where condition checks value of your dimension)?

iliyansomlev · ‎2014-02-03

the expressions all of you mention don't work, I have tried them and also aggr and others. I don't know what is the problem

Aurelien_Martinez · ‎2014-02-03

Ok, remove your calculed dimension and use DateUse

Help users find answers! Don't forget to mark a solution that worked for you!

iliyansomlev · ‎2014-02-03

it's the same result - not working; only when Weekday is added as dimension this fixes the background color of DateUse, but I don't want to add additional dimesnion (cannot make labels vertical then) and I don't understand why background color doesn't work when it is one-to-one unique relationship (DateUse to WeekDay)

Anonymous · ‎2014-02-03

Lliyan

Is the attached what you are after ?

Best Regards, Bill

Dimension background color in a pivot table (QV 11.2 SR 5)