display data for weekly based on date in qliksense

[berryandcherry6]

Hi,

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.

Date	UserType	Pageviews
16-12-2015	New Visitor	77
16-12-2015	Returning Visitor	36
17-12-2015	New Visitor	72
17-12-2015	Returning Visitor	16
18-12-2015	New Visitor	82
18-12-2015	Returning Visitor	11
19-12-2015	New Visitor	113
19-12-2015	Returning Visitor	39
20-12-2015	New Visitor	19
20-12-2015	Returning Visitor	16
21-12-2015	New Visitor	41
21-12-2015	Returning Visitor	27
22-12-2015	New Visitor	60

Any kind of help is appreciated on this

Regards,

Supriya

[Gysbert_Wassenaar · Accepted solution]

Create a week field in the script and use that as dimension:

LOAD

     Date,

     Dual(Date(WeekStart(Date),'DD/MM/YYYY') & '-'

          & Date(WeekEnd(Date),'DD/MM/YYYY'), WeekStart(Date)) as Week,

     UserType,

     Pageviews

FROM

     ....source data...

     ;