LOAD * INLINE
WeekDay(Date) as WeekDay,
Day(Date) as Day,
Dual('Week ' & wEEK(Date), wEEK(Date)) as Week,
Month(Date) as Month,
Year(Date) as Year
w.qvw 155.5 K
Hi, some things to comment:
- Your DateFormat variable has different from than the one you have in your inline table, so you need to use Date#() to tell QV the dateformat he is reading.
- You need to link both tables so I added the Date field to the 2nd table, just with that both tables are linked by date
- Not absolutely needed, but I renamed some fields of the 2nd table
- I also added the 'Week' string to the week field, using Dual() to keep the numeric value
With this I created a chart by week and an expression for each day using set analisys, PFA
Edit: as swhuel said, it's easier just switching dimensions, I updated the attachment.
w.qvw 157.0 K
please go through these 3 steps:
i) Change your script like this:
Take care of the date format and add the date field in the second table also.
ii) In the user interface add a bar chart with these dimensions:
First Week then Weekday.
iii) Enter these two expressions and see the result:
Hope this helps