topic Re: Exclude only sunday in QlikView

Exclude only sunday

Wed, 11 May 2016 12:19:47 GMT

Hi ,

1) how can i calculated the data excluding only sunday's in a year .

2) how can i calculated the data excluding both saturday and sunday's in a year .

Thanks in advance

Re: Exclude only sunday

MindaugasBacius — Wed, 11 May 2016 14:01:58 GMT

1. Make two flags in your load scrip:

If(weekday(Date) = 6, 1, 0) as Flag_Sunday

If(weekday(Date) = 5 or weekday(Date) = 6, 1, 0) as Flag_Saturday_Sunday

And use set analysis in calculations.

2. Or make Weekday field and use it also in set analysis.

Re: Exclude only sunday

marcus_sommer — Wed, 11 May 2016 14:48:08 GMT

In addition to the suggestion from mindaugasbacius you could also reverse the logic by creating a flag for a working day to calculate later directly with the flag without the need of set analysis:

If(weekday(Date) < 5, 1, 0) as Flag_Workingday

and then within your objects: sum(AnyValue*Flag_Workingday)

- Marcus