topic Shifting multiples days in set analysis in QlikView https://community.qlik.com/t5/QlikView/Shifting-multiples-days-in-set-analysis/m-p/690409#M1083047 <HTML><HEAD></HEAD><BODY><P><BR />Hi all,</P><P></P><P>This may be simple question, but I am not experienced with set analisys.</P><P>I would like to compare recent sales with corresponding period in the previous year. I used the set expression:</P><P>Year={$(=(Only(Year)-1))} for the previous year. However, the period corresponding to, lets say, 9-20 of June 2014 should be 10-21 of June 2013. So I need move days range by 1.</P><P>Formula Day={$(=(Only(Day)-1))} won't work when multiple days are selected. How could I force QV to display values for the period "shifted" by one day?</P><P></P><P>Thanks in advance</P><P></P><P>Marcin</P></BODY></HTML> Tue, 01 Jul 2014 14:07:53 GMT 2014-07-01T14:07:53Z Shifting multiples days in set analysis https://community.qlik.com/t5/QlikView/Shifting-multiples-days-in-set-analysis/m-p/690409#M1083047 <HTML><HEAD></HEAD><BODY><P><BR />Hi all,</P><P></P><P>This may be simple question, but I am not experienced with set analisys.</P><P>I would like to compare recent sales with corresponding period in the previous year. I used the set expression:</P><P>Year={$(=(Only(Year)-1))} for the previous year. However, the period corresponding to, lets say, 9-20 of June 2014 should be 10-21 of June 2013. So I need move days range by 1.</P><P>Formula Day={$(=(Only(Day)-1))} won't work when multiple days are selected. How could I force QV to display values for the period "shifted" by one day?</P><P></P><P>Thanks in advance</P><P></P><P>Marcin</P></BODY></HTML> Tue, 01 Jul 2014 14:07:53 GMT https://community.qlik.com/t5/QlikView/Shifting-multiples-days-in-set-analysis/m-p/690409#M1083047 2014-07-01T14:07:53Z