topic Many Years in QlikView https://community.qlik.com/t5/QlikView/Many-Years/m-p/382660#M142823 <HTML><HEAD></HEAD><BODY><P>I have many years in my database.</P><P></P><P>So I put </P><P>Table:</P><P>Load</P><P>Year</P><P>Monh</P><P>Resident TT</P><P>Where Year 2010 And Year 2011</P><P>Order By Month</P><P></P><P>Year goes 0.</P><P></P><P>With Or just show 2010</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 30 Aug 2012 17:36:09 GMT pgalvezt 2012-08-30T17:36:09Z Many Years https://community.qlik.com/t5/QlikView/Many-Years/m-p/382660#M142823 <HTML><HEAD></HEAD><BODY><P>I have many years in my database.</P><P></P><P>So I put </P><P>Table:</P><P>Load</P><P>Year</P><P>Monh</P><P>Resident TT</P><P>Where Year 2010 And Year 2011</P><P>Order By Month</P><P></P><P>Year goes 0.</P><P></P><P>With Or just show 2010</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 30 Aug 2012 17:36:09 GMT https://community.qlik.com/t5/QlikView/Many-Years/m-p/382660#M142823 pgalvezt 2012-08-30T17:36:09Z Re: Many Years https://community.qlik.com/t5/QlikView/Many-Years/m-p/382661#M142824 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Try like this,</P><P>Edit:</P><P>Use or instead of and</P><P></P><P>Load</P><P>Year</P><P>Monh</P><P>Resident TT</P><P>Where Year = 2010 or Year = 2011;</P><P></P><P>Hope it helps</P></BODY></HTML> Thu, 30 Aug 2012 17:38:52 GMT https://community.qlik.com/t5/QlikView/Many-Years/m-p/382661#M142824 MayilVahanan 2012-08-30T17:38:52Z Re: Many Years https://community.qlik.com/t5/QlikView/Many-Years/m-p/382662#M142825 <HTML><HEAD></HEAD><BODY><P>did You write?</P><P></P><P><STRONG>where Year=2010 or Year=2011</STRONG> </P><P></P><P>i believe this should work...</P></BODY></HTML> Thu, 30 Aug 2012 17:40:19 GMT https://community.qlik.com/t5/QlikView/Many-Years/m-p/382662#M142825 2012-08-30T17:40:19Z Re: Many Years https://community.qlik.com/t5/QlikView/Many-Years/m-p/382663#M142826 <HTML><HEAD></HEAD><BODY><P><STRONG>where Year=2010 or Year=2011</STRONG></P><P></P><P>Just bring me 2010</P></BODY></HTML> Thu, 30 Aug 2012 17:46:44 GMT https://community.qlik.com/t5/QlikView/Many-Years/m-p/382663#M142826 pgalvezt 2012-08-30T17:46:44Z Re: Many Years https://community.qlik.com/t5/QlikView/Many-Years/m-p/382664#M142827 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Can you check load once and check whether year = 2011 available?</P></BODY></HTML> Thu, 30 Aug 2012 17:52:32 GMT https://community.qlik.com/t5/QlikView/Many-Years/m-p/382664#M142827 MayilVahanan 2012-08-30T17:52:32Z Re: Many Years https://community.qlik.com/t5/QlikView/Many-Years/m-p/382665#M142828 <HTML><HEAD></HEAD><BODY><P>reverse the where statement and tell us what is the result</P><P></P><P><STRONG style="background-color: #eef4f9; font-size: 12.222222328186035px; color: #636363; font-family: Arial;">where Year=2011 or Year=2010</STRONG></P></BODY></HTML> Thu, 30 Aug 2012 18:04:51 GMT https://community.qlik.com/t5/QlikView/Many-Years/m-p/382665#M142828 2012-08-30T18:04:51Z Re: Many Years https://community.qlik.com/t5/QlikView/Many-Years/m-p/382666#M142829 <HTML><HEAD></HEAD><BODY><P>hmmm interesting...</P><P></P><P>reversing 2010 and 2011 fix the problem?</P></BODY></HTML> Thu, 30 Aug 2012 19:16:57 GMT https://community.qlik.com/t5/QlikView/Many-Years/m-p/382666#M142829 2012-08-30T19:16:57Z Re: Many Years https://community.qlik.com/t5/QlikView/Many-Years/m-p/382667#M142830 <HTML><HEAD></HEAD><BODY><P>Yes, very wire because I reloaded the model again and fix the problem. Any case many thanks.</P></BODY></HTML> Thu, 30 Aug 2012 19:22:54 GMT https://community.qlik.com/t5/QlikView/Many-Years/m-p/382667#M142830 pgalvezt 2012-08-30T19:22:54Z Re: Many Years https://community.qlik.com/t5/QlikView/Many-Years/m-p/382668#M142831 <HTML><HEAD></HEAD><BODY><P>Cool.</P><P>Could you try also where (Year=2010) or (Year=2011)</P></BODY></HTML> Thu, 30 Aug 2012 19:24:08 GMT https://community.qlik.com/t5/QlikView/Many-Years/m-p/382668#M142831 whiteline 2012-08-30T19:24:08Z Re: Many Years https://community.qlik.com/t5/QlikView/Many-Years/m-p/382669#M142832 <HTML><HEAD></HEAD><BODY><P>Ok! Thank you for your advice. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 30 Aug 2012 19:25:52 GMT https://community.qlik.com/t5/QlikView/Many-Years/m-p/382669#M142832 pgalvezt 2012-08-30T19:25:52Z