Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

Compare sales of today (dd/mm/yyy) with sales of same day last year

Hello,

Hope you can help me!

I need to build a chart with the sales info of this year  (column) day per day (rows) and the sales info of this day but last year  (column). I mean, don´t have to compare with the exact date, but with the date that this weekday last year was.

In my database, among other data, I have a column with all the dates day per day of this year and last year (dd/mm/yyy) and another column with their respective sales per day.

EXAMPLE DATA BASE:

Date                Sales

01/08/2016     15.000
01/08/2015     11.000
02/08/2016     23.000
02/08/2015     12.000

03/08/2016     14.000

03/08/2015     19.000
04/08/2016     10.000

04/08/2015     16.000

EXAMPLE REQUIREMENT

Date                Sales       Sales LY      Dif.   

01/08/2016     15.000     19.000         - 4.000 

02/08/2016     23.000     16.000           7.000

**Comparing 01/08/2016 with 03/08/2015 (same weekday last year) 

Surely it is quite simple, but I'm stuck and I need some help :S

Thank you!!