Week days color

[#1]

Hi,

I am having a list box in horizontal direction with seven columns to show the week days.

"weekday(date(makedate(year, month, day), 'YYYY-MM-DD')) AS Week" : here Week is my field name.

I want to show the weekends in red color. How to achive it?

Thanks

[Anonymous]

List box have limitations on conditional formatting.

1. Create field in your load statement: weekday(date(makedate(year, month, day), 'YYYY-MM-DD')) AS YourWeek
2. Create a straight table, use YourWeek as a dimension, click on the + sign to the left and add conditional format statement like if(YourWeek > 5, red()) in the editor when you double click on 'Text Color'
3. In the expression: sum(1). In the presentation, hide the column sum(1).

The disadvantage is that you will loose the horizontal alignment.

Regards,

Dinesh.

[montubhardwaj]

Dinesh is right and we dont have conditional formatting for list box. But you can achieve this by doing some workarounds. Attached is the example using Dinesh's approach.