Qlik Community

Qlik Sense App Development

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

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 Smiley Frustrated

Thank you!!

Community Browser