topic Like Wise Analysis in QlikView https://community.qlik.com/t5/QlikView/Like-Wise-Analysis/m-p/188602#M51792 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>i think this will help you</P><P>for year 2009</P><P>Sum(if(Year='2009', and year='2010',Sales))</P><P></P><P></P><P>good luck</P></BODY></HTML> Mon, 22 Mar 2010 11:59:32 GMT SunilChauhan 2010-03-22T11:59:32Z Like Wise Analysis https://community.qlik.com/t5/QlikView/Like-Wise-Analysis/m-p/188601#M51791 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I need to Make a like wise analysis on the basis on Year . I need to pick only those product whos sales Is there in 2009 and the same product Cmparison need to be in in 2010.</P><P></P><P>I have attach the data file. IN the file example I should not select Product C since it not there in 2009.</P><P></P><P>Thanks</P><P>Deepak</P><P></P><P></P><P></P></BODY></HTML> Mon, 22 Mar 2010 11:48:34 GMT https://community.qlik.com/t5/QlikView/Like-Wise-Analysis/m-p/188601#M51791 deepakk 2010-03-22T11:48:34Z Like Wise Analysis https://community.qlik.com/t5/QlikView/Like-Wise-Analysis/m-p/188602#M51792 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>i think this will help you</P><P>for year 2009</P><P>Sum(if(Year='2009', and year='2010',Sales))</P><P></P><P></P><P>good luck</P></BODY></HTML> Mon, 22 Mar 2010 11:59:32 GMT https://community.qlik.com/t5/QlikView/Like-Wise-Analysis/m-p/188602#M51792 SunilChauhan 2010-03-22T11:59:32Z Like Wise Analysis https://community.qlik.com/t5/QlikView/Like-Wise-Analysis/m-p/188603#M51793 <HTML><HEAD></HEAD><BODY><P>Sorry This Doesnt Work.........!!!</P></BODY></HTML> Mon, 22 Mar 2010 12:35:26 GMT https://community.qlik.com/t5/QlikView/Like-Wise-Analysis/m-p/188603#M51793 deepakk 2010-03-22T12:35:26Z