topic Re: Set Analysis Questions: Cumulative function in the past in QlikView

Set Analysis Questions: Cumulative function in the past

Tue, 06 May 2014 10:02:24 GMT

Hello,

I want to compare a period of this year with the same period last year.

For example: Jan, Feb, Mrt 2014 vs Jan, Feb, Mrt 2013.

I have now the following, but it doesn't work proper:

sum({$<Date = {">=$(=Date(addyears(Min(Date), -1)))"}, Date -= {"<=$(=Date(addyears(Max(Date), -1)))"}>}visitors)

It is on expressions level and has to work wiht selections.

Can you give a suggestion what to change?

Thanks,

Marc

Re: Set Analysis Questions: Cumulative function in the past

Tue, 06 May 2014 10:07:26 GMT

Look here:

Re: Set analysis with sequence numbers (go back twelve months)

Re: compare data with month from previous year

regards

Darek

Re: Set Analysis Questions: Cumulative function in the past

Tue, 13 May 2014 10:00:16 GMT

Hi Dariusz,

I look into your answer. And use these functions, but it didn't work. I must also use selections on Date,MonthYear, Year.

Can anyone help my furhter?

Regards,

Marc

Re: Set Analysis Questions: Cumulative function in the past

Tue, 13 May 2014 12:31:37 GMT

try this:

sum({$<Date = {">=$(=Date(addyears(Min(Date), -1)))<=$(=Date(addyears(Max(Date), -1)))"}>}visitors)

Re: Set Analysis Questions: Cumulative function in the past

Tue, 13 May 2014 15:02:59 GMT

This works for the date selction, but not for the MonthYear, Year selection. Is that also possible?

Re: Set Analysis Questions: Cumulative function in the past

Tue, 13 May 2014 15:08:39 GMT

Soory, the date function look likes it work but it doesn't. It gives the same result as current year selection.

Re: Set Analysis Questions: Cumulative function in the past

Tue, 13 May 2014 19:47:04 GMT

Marc,

the best idea for those type of questions is to attach sample application. It will let somebody to see your data model, data, etc. It is much easier to help.

Regards

Darek

Re: Set Analysis Questions: Cumulative function in the past

Mon, 19 May 2014 09:49:46 GMT

The one which works now is:

sum({$<date = {">=$(=date(addyears(Min(date), -1))) <=$(=date(addyears(Max(date), -1)))"},

Re: Set Analysis Questions: Cumulative function in the past

antoniotiman — Mon, 19 May 2014 10:22:46 GMT

Marc,

try to replace sum({$<date... with sum({1<date...

Re: Set Analysis Questions: Cumulative function in the past

preminqlik — Mon, 19 May 2014 11:04:06 GMT

you are almost there , you have to ignore the selections , since you already used the field named "Date" see below

sum({$<Date = {">=$(=Date(addyears(Min(Date), -1)))<=$(=Date(addyears(Max(Date), -1)))"},Year=,Month=,Quarter=>}visitors)