topic Re: Supress Weekend Names in QlikView

Supress Weekend Names

Fri, 22 May 2015 12:03:46 GMT

I have a straight table withg data showing working dates only.

I would like to add a field showing the weekday name. I used the below function.

=weekday(DATE)

Problem is, now my straight table shows the weekends as well and I cannot find a way to suppress them.

Any ideas?

sunny_talwar — Fri, 22 May 2015 12:09:04 GMT

You are back my friend .

Try this:

If(Weekday(DATE) <> 'Sat' or Weekday(DATE) <> 'Sun', WeekDay(DATE))

Best,

Sunny

sunny_talwar — Fri, 22 May 2015 12:12:08 GMT

Actually since we are checking for nots, I think it should be 'and' and not 'or'

Try this instead:

If(Weekday(DATE) <> 'Sat' and Weekday(DATE) <> 'Sun', WeekDay(DATE))

If that doesn't work, then this should def. wor:

If(Match(WeekDay(DATE), 'Mon', 'Tue', 'Wed', Thu', 'Fri'), WeekDay(DATE))

Best,

Sunny

swuehl — Fri, 22 May 2015 12:13:57 GMT

You can also try using

=weekday(DATE)

as calculated dimension, not as expression.