Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Display only weekdays on line chart

We are creating a line chart using day a dimension and we would like to only display weekdays (Monday through Friday, not Sat and Sun). Is there a simple way to do this without deselecting the "show all values" box and make a calculated dimension based on an if statement.

Thank you!

2 Replies

Re: Display only weekdays on line chart

Hi Roya, not sure of how is your data or if you have a date field, you can try set an if in expression like this:

If(weekday(fecha)<5, expression)

ecolomer
Honored Contributor II

Re: Display only weekdays on line chart

For Week End only use this dimension:

=if(Num(WeekDay(xDate))<5, WeekDay(xDate))    for labour week

=if(Num(WeekDay(xDate))>4, WeekDay(xDate)) for Week End

where xDate is your field DATE

p01.png

Community Browser