Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Set analysis with date



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

2 Replies
Community Manager
Community Manager

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

Sue Macaluso
Contributor II
Contributor II