Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am still new to QlikView and I am taking in values from an excel sheet and would like to exclude the values in a straight table that fall on a Saturday or Sunday. The values are being input into the excel sheet in the form of MM/DD/YYYY, and whenever I try the command:
WeekDay(Date(Date))
I get Saturday, or more specifically 'Sat', every time, even though the second date refers to the column containing the dates. How can I achieve my desired result?
try with
=WeekDay(Date#(Date,'MM/DD/YYYY'))
or with
=WeekDay(Date)