Discussion Board for collaboration related to QlikView App Development.
i have a data like shown below, it contains all dates from when application started to till date and its respective datas.
Now i need to put a line graph with Dimension - Date(Monday to Sunday), UserType . Measure - Pageviews. But data display should be weekly from Monday to Sunday.
i.e for example : 05/12/2016 - 11/12/2016 ,for New visitor it should display sum of Pageviews and for Returning Visitor it should display sum of Pageviews.
Any kind of help is appreciated on this
Create a week field in the script and use that as dimension:
Dual(Date(WeekStart(Date),'DD/MM/YYYY') & '-'
& Date(WeekEnd(Date),'DD/MM/YYYY'), WeekStart(Date)) as Week,
View solution in original post