topic Using a current selection (YEAR) to look at Previous Year with set analysis in QlikView

Using a current selection (YEAR) to look at Previous Year with set analysis

Fri, 07 Feb 2014 12:18:28 GMT

Based on a current selection (of DEPARTURE YEAR) im trying to look at data from that current selected year minus one year, and for (BOOKED_DATE) to be a year ago to date.

So a total snapshot of the situation this time last year - I've tried the below set analyis and this does not work - how can I combine the field selection?

({$<DEPARTURE_YEAR = {$(=GetFieldSelection(DEPARTURE_YEAR)-1)}>} BOOKED_DATE <=dayend (TODAY(),-365, PASS_NO))

Re: Using a current selection (YEAR) to look at Previous Year with set analysis

Fri, 07 Feb 2014 12:30:22 GMT

Hi James,

Are using any aggregation function?

Regards,

Shameem.

Re: Using a current selection (YEAR) to look at Previous Year with set analysis

Gysbert_Wassenaar — Fri, 07 Feb 2014 13:44:28 GMT

No idea if you want to use count or max or sum or whatever, but the set modifier for booked date wasn't correct. Try something like:

count({$<DEPARTURE_YEAR = {'$(=max(DEPARTURE_YEAR)-1)'}, BOOKED_DATE={'<$(=makedate(max(DEPARTURE_YEAR)-1))+DayNumberOfYear(today())+1)'} PASS_NO)

Re: Using a current selection (YEAR) to look at Previous Year with set analysis

Mon, 10 Feb 2014 11:51:29 GMT

Thanks Gusbert, I think I am almost there but essentially im using the Getfieldselection , which means the departure is variable. So if 2014 was selected I want to see 2014 and 2013 data (a snap shot of this time last year). So a Year on Year comparison.