Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

mila_ayuhara
New Contributor III

How to color weekends in a date dimension to distinguish them from weekdays

Hello QlikView-Community,

i have a bar-chart, where the dimension of the x-axis is a date:

Date_Diagramm.png

Now i want to have a visiual aid to distinguish weekdays from weekends in the x-axis by for example coloring weekends red and weekdays green.

Till now i have only figured out, that i can color the x.axis in the tab axis and clicking font for the dimensionaxis. There i can chose the color even by a function, but the function is not workin as i want it. So the outcome is that all values have the same color, which doesnt help to distinguish the weekdays from weekends.

Does anybody know how to color the weekends?

Thanks in advance.

Best greetings.

Mila

Tags (4)
4 Replies
bismart
Contributor

Re: How to color weekends in a date dimension to distinguish them from weekdays

Have a look at this sample app...

Check out the background property in the expression in the chart

mila_ayuhara
New Contributor III

Re: How to color weekends in a date dimension to distinguish them from weekdays

Thanks for the fast answer. I actually meant to color the values of the date dimension like'1 Jan' or '22 feb' and not to color the values of the function. Do you have an idea how to do this?

Best greetings

Mila

Re: How to color weekends in a date dimension to distinguish them from weekdays

Hi,

     I think its not possible in bar chart.

     If it is a pivot or straight table you can go by click the expand icon of the Dimension and Entering Text color as

     =if(WeekDay(date)>4,red(),green())

Hope it helps

Celambarasan

chandashok
Contributor III

Re: How to color weekends in a date dimension to distinguish them from weekdays

Hi

     Hope this attached file will be helpful for your requirement.

     Here the weekends Sat and Sun is one color and other weekend days from mon to fri is one color

     Check it,

Regards

Community Browser