Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Reporting sales for a date and sales for past 3 days from that date as a continuous trend in a chart

DateSalesSales in past 3 daysSales from 6-4 days in pastin pastSales from 9-7 days in past
01.09.201210

10

0

0
02.09.201251500
03.09.2012

6

2100
04.09.2012102110 0
05.09.2012723

15

0
06.09.2012421210
07.09.201221321 (from 04.09.2012 to 06.09.2012)10 (from 01.09.2012 to 03.09.2012)
08.09.2012172315
09.09.2012362121
10.09.2012591321
11.09.2012816723
12.09.2012922621
13.09.2012724913
14.09.20121026167
15.09.2012522226

Sample Data

The first two columns represent the actual data sample and the entire table ablove is the expected output in qlikview. Pleas help to achieve this output in Qlikview with set analysis or any other implementation

2 Replies
jvitantonio
Valued Contributor III

Re: Reporting sales for a date and sales for past 3 days from that date as a continuous trend in a chart

Hi, here's the solution. I hope it helps.

Not applicable

Re: Reporting sales for a date and sales for past 3 days from that date as a continuous trend in a chart

Thanks a lot for the answer. Is it possible to achieve the same results in set analysis ?

Community Browser