WeekDay() working in two documents but not one other

Thu, 26 Aug 2010 21:18:11 GMT

We have a single QVW document with data only that we load in to other documents with script command:

Binary dataBinary.qvw;

In the dataBinary.qvw file we have a field:

WeekDay(RollupDate) as "Day of Week",

When looking at the "Day of Week" field in databinary.qvw it shows text "Days of Week":

Mon
Tue
Wed
Thu
Fri
Sat
Sun

In two of the documents that we load dataBinary.qvw it also shows text for "Days of Week", which is what we want.

In the third document that we load dataBinary.qvw into it show "Days of Week" as integers:

0
1
2
3
4
5
6

All three of the documents have in their scripts:

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

what could be causing the third document to be displaying "Days of Week" as integers? We want the text 🙂

WeekDay() working in two documents but not one other

vgutkovsky — Fri, 27 Aug 2010 01:12:21 GMT

Hmmm...that's strange. Try enclosing your original date in the date() function. If it's being seen as a num, it's possible that's the problem. So something like: weekday(date(RollupDate)) as [Day of Week]

Regards,

topic WeekDay() working in two documents but not one other in QlikView

WeekDay() working in two documents but not one other

WeekDay() working in two documents but not one other