Discussion Board for collaboration on QlikView Scripting.
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
Go to Solution.
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,