topic When user select year = 2013 , how to write my expression can display 2017 YTD sales ? in QlikView https://community.qlik.com/t5/QlikView/When-user-select-year-2013-how-to-write-my-expression-can/m-p/1276252#M619914 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P></P><P>I have 3 Table , may i know how to combine into 1 table ?</P><P></P><P></P><P>sheet 2013 = year 2013 compare to CY</P><P>sheet 2014 = year 2014 compare to CY</P><P>sheet 2015 = year 2015 compare to CY</P><P></P><P></P><P>Meaning instead of having 3 sheet , i only wan to have 1 sheet.</P><P></P><P></P><P>So when user </P><P></P><P></P><P>select year = 2013 , it will display 2013 compare with current year.</P><P>select year = 2014 , it will display 2014 compare with current year.</P><P>select year = 2015 , it will display 2015 compare with current year.</P><P></P><P></P><P></P><P></P><P>Hope some one can advise me.</P><P></P><P></P><P>As i don't know how to make the second display 2017 YTD sales when user select year =2013.</P><P></P><P></P><P></P><P></P><P>Paul</P></BODY></HTML> Mon, 13 Mar 2017 07:58:00 GMT paulyeo11 2017-03-13T07:58:00Z When user select year = 2013 , how to write my expression can display 2017 YTD sales ? https://community.qlik.com/t5/QlikView/When-user-select-year-2013-how-to-write-my-expression-can/m-p/1276252#M619914 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P></P><P>I have 3 Table , may i know how to combine into 1 table ?</P><P></P><P></P><P>sheet 2013 = year 2013 compare to CY</P><P>sheet 2014 = year 2014 compare to CY</P><P>sheet 2015 = year 2015 compare to CY</P><P></P><P></P><P>Meaning instead of having 3 sheet , i only wan to have 1 sheet.</P><P></P><P></P><P>So when user </P><P></P><P></P><P>select year = 2013 , it will display 2013 compare with current year.</P><P>select year = 2014 , it will display 2014 compare with current year.</P><P>select year = 2015 , it will display 2015 compare with current year.</P><P></P><P></P><P></P><P></P><P>Hope some one can advise me.</P><P></P><P></P><P>As i don't know how to make the second display 2017 YTD sales when user select year =2013.</P><P></P><P></P><P></P><P></P><P>Paul</P></BODY></HTML> Mon, 13 Mar 2017 07:58:00 GMT https://community.qlik.com/t5/QlikView/When-user-select-year-2013-how-to-write-my-expression-can/m-p/1276252#M619914 paulyeo11 2017-03-13T07:58:00Z Re: When user select year = 2013 , how to write my expression can display 2017 YTD sales ? https://community.qlik.com/t5/QlikView/When-user-select-year-2013-how-to-write-my-expression-can/m-p/1276253#M619915 <HTML><HEAD></HEAD><BODY><P>My QVW</P></BODY></HTML> Mon, 13 Mar 2017 07:58:41 GMT https://community.qlik.com/t5/QlikView/When-user-select-year-2013-how-to-write-my-expression-can/m-p/1276253#M619915 paulyeo11 2017-03-13T07:58:41Z