topic Re: Excluding row in Table in QlikView

Excluding row in Table

Thu, 03 Jul 2014 13:47:10 GMT

I have a straight table and have a set of dates in addition to other information. What I am trying to do is remove a whole row whose date is on a Saturday or Sunday. My question is where I can achieve such a function. I have been trying different commands in the expressions tab of the properties of the table, but either the whole column of dates goes away or it does not change at all. I was wondering if anyone had any suggestions for achieving my desired result. My question does not like necessarily on how to get the Saturday and Sunday, but rather how to exclude the whole row whose WeekDay coincides with those ones.

Re: Excluding row in Table

ashfaq_haseeb — Thu, 03 Jul 2014 13:54:40 GMT

Hi,

try below

in your script

LOAD

weekday(CalendarDate) as WeekDay

From Table1;

Then, you can use in your expression

sum({<WeekDay-={6,7}>} Sales)

Re: Excluding row in Table

juleshartley — Thu, 03 Jul 2014 14:01:56 GMT

...or just use an expression:

Sum(

If(Weekday(Max(CalendarDate)<5,Sales))

Re: Excluding row in Table

Thu, 03 Jul 2014 14:13:31 GMT

So, just to clarify, I am using the sample data as provided by QlikView, and my straight table includes the Customer as a dimension, and all the other possible fields as an expression. By including the above code, will it remove the values associated with that date? Just a bit confused by the Sum method stated.

Re: Excluding row in Table

ashfaq_haseeb — Fri, 04 Jul 2014 07:53:48 GMT

Hi,

Just give a try, or share a sample app if possible.

Regards

ASHFAQ