topic Week days color in QlikView

Week days color

Thu, 28 Apr 2011 13:58:22 GMT

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

Week days color

Anonymous — Thu, 28 Apr 2011 15:19:33 GMT

List box have limitations on conditional formatting.

Create field in your load statement: weekday(date(makedate(year, month, day), 'YYYY-MM-DD')) AS YourWeek
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'
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.

Week days color

montubhardwaj — Thu, 28 Apr 2011 15:46:45 GMT

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.