Excluding row in Table

[#1]

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.

[ashfaq_haseeb]

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)

[juleshartley]

...or just use an expression:

Sum(

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

[#4]

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.

[ashfaq_haseeb]

Hi,

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

Regards

ASHFAQ