Set analysis with date

[linhphuong]

Hi, 

Data:

20190101 (column1 ),  BudgetValue, 20180101 (column1 minus 1 year)

20190201,   BudgetValue,  20180201

20190301, BudgetValue,  20180301

....

From 2012 until now.

I want to use set analysis to create a graph that compare last year with this year for selected column1 (date).

So example

If I want to select column1 20190101 and 20190201 the graph will show 20190101 and 20190201 as one datapoint

20180101 and 20180201 will show as another datapoint.

I manage to compare with one date with another exampel 20190101 compared with 20180101, but the graph doesn't show anything when I select multiple dates. I used this formula

sum({<[Column1]={"$(=DATE([column1 minus 1 year]))"}>}Budget)

Thanks in advance

[Sue_Macaluso]

@linhphuong  Are you using QlikView or Sense.  This forum is for general discussions and I'd like to move this into the correct product forum. 

[linhphuong]

Qlikview