topic Re: Exception for certain day in QlikView

Exception for certain day

Anonymous — Fri, 06 Feb 2015 07:31:32 GMT

Date Task

30/1/2015 A

31/1/2015 B

1/2/2015 C

2/2/2015 D

3/2/2015 E

Expected result should exclude the saturday and sunday date.

Date Task

30/1/2015 A

2/2/2015 D

3/2/2015 E

Kindly help. Thanks.

Re: Exception for certain day

tresB — Fri, 06 Feb 2015 07:36:10 GMT

You could try calculated dimension like:

If( Not Match( WeekDay(Date), 'Sat', 'Sun'), Date)

Then enable supress when value is null in the dimensions tab.

Re: Exception for certain day

its_anandrjs — Fri, 06 Feb 2015 07:38:04 GMT

In a table or chart you want to get this out put let me know.

Regards

Aannd

Re: Exception for certain day

anbu1984 — Fri, 06 Feb 2015 07:41:50 GMT

Set DayNames = 'Monday;Tuesday;Wednesday;..'

Load * Where Not Match(Weekday(Date),'Saturday','Sunday'));
Load Date#(Date,'DD/MM/YYYY') As Date,Task Inline [
Date,Task
30/1/2015,A
31/1/2015,B
1/2/2015,C
2/2/2015,D
3/2/2015,E
];

Re: Exception for certain day

avinashelite — Fri, 06 Feb 2015 07:48:04 GMT

in dimension try like this:

If( WeekDay(Date)<> 'Sat' or WeekDay(Date)<>'Sun', Date)

and then suppress null in the dimension

Re: Exception for certain day

its_anandrjs — Fri, 06 Feb 2015 07:50:49 GMT

Hi,

In front end you can try this way

Dim:- Date

Expre:- =If( Not Match( WeekDay(Date), 'Sat', 'Sun'), Only(Task))

Regards

Anand

Re: Exception for certain day

kamielrajaram — Fri, 06 Feb 2015 08:21:32 GMT

Hi,

With date as dimension, in your expression add

Only(if(num(WeekDay(Date)) < 5,Task))

Regards

Kamiel