Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
linhphuong
New Contributor II

Set analysis with date

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

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

Re: Set analysis with date

Qlikview