topic Re: Create a column with weekdays and All days in QlikView

Create a column with weekdays and All days

qliklearnervir — Sat, 16 Nov 2024 18:11:50 GMT

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.

tresB — Mon, 24 Aug 2020 13:10:11 GMT

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 — Mon, 24 Aug 2020 13:17:05 GMT

Can you please elaborate?