Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

New 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

Tags (2)
2 Replies
Community Manager
Community Manager

Re: Set analysis with date

@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
New Contributor II

Re: Set analysis with date