display data for weekly based on date in qliksense

berryandcherry6 — Wed, 14 Dec 2016 07:54:29 GMT

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

Re: display data for weekly based on date in qliksense

Gysbert_Wassenaar — Wed, 14 Dec 2016 09:32:55 GMT

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...

;

topic display data for weekly based on date in qliksense in QlikView

display data for weekly based on date in qliksense

Re: display data for weekly based on date in qliksense