Create a column with weekdays and All days

[qliklearnervir]

HI,

I have 1 service_date column, where the client wants to create a filter field to select weekdays and all days.

Like when i select weekdays than it should select the number of total days for weekdays in the service_date column.

when i select all days than it should select the number of total days for all days in the service_date column.

[tresesco · Accepted solution]

You can try like:

Load

        service_date,

         If( Not Match(Weekday(service_date), 'Sat', 'Sun'), 'WeekDay') as WeekdayFlag

From <>;

Concatenate

Load

        service_date,

         'AllDays' as WeekdayFlag

From <>;

[Kushal_Chawda]

Can you please elaborate?