topic Re: Exclude Saturday and Sunday in QlikView

Exclude Saturday and Sunday

Thu, 10 Apr 2014 12:21:48 GMT

I have a simple expression which give me a line chart where the only dimenion is CalendarDate

COUNT (DISTINCT UserName)

Can I use a set analysis in this expression to excluded Saturdays and Sundays from the chart? If so, how?!

yduval75 — Thu, 10 Apr 2014 12:25:17 GMT

Yes,

in your script

LOAD

weekday(CalendarDate) as WeekDay

From Table1;

Then, you can use in your expression

COUNT ({<WeekDay-={6,7}>} DISTINCT UserName)

MK_QSL — Thu, 10 Apr 2014 12:29:27 GMT

Create below line in your script...

IF(WeekDay(CalendarDate)=5 or WeekDay(CalendarDate)=6, 1,0) as WeekDayFlag

Now use as below..

COUNT ({<WeekDayFlag = {'0'}>}DISTINCT UserName)

Thu, 10 Apr 2014 12:33:55 GMT

Thanks Yoann, i adpated that and it worked perfectly!

COUNT({$<CalendarDayName-={'Sat','Sun'}>} DISTINCT UserName)

MK_QSL — Thu, 10 Apr 2014 12:36:28 GMT

For your information..

weekday in qlikview starts from Monday as 0 and ends at Sunday as 6....

so no 7...