Set analysis with date

linhphuong — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Set analysis with date

Sue_Macaluso — Wed, 29 May 2019 13:55:41 GMT

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

Re: Set analysis with date

linhphuong — Wed, 29 May 2019 14:12:36 GMT

Qlikview

topic Re: Set analysis with date in QlikView

Set analysis with date

Re: Set analysis with date

Re: Set analysis with date