Discussion Board for collaboration on QlikView Layout & Visualizations.
I've this application in attach. I'm trying to build a chart that shows all the days per week. When I'm trying to create it, I obtain this chart:
But I want to tho show all day weeks by Week. Someting like this:
Basically, I want to show all the days from the weeks in chart.
Go to Solution.
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
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
Looks like you just need to change the order of dimensions.
See attached (needed to recreate most, because your sample showed empty sheets and unlinked tables),
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.
Thank you but what I want to show in chart is the day of the week repeatedly: