topic Comparing Time periods in QlikView https://community.qlik.com/t5/QlikView/Comparing-Time-periods/m-p/302641#M1202809 <HTML><HEAD></HEAD><BODY><P>The time chart wizard is driving me crazy!!</P><P>I have the following data</P><P></P><P>Balance 200 asofdate 12/31/2010</P><P>Balance 210 asofdate 09/30/2010</P><P></P><P>I want to get 4 columns</P><P>Balance 9/30/2010 Balance 12/31/2010 Diff $ Diff%</P><P>210 200 10 5%</P><P>I know I can write 2 expressions using 9/30/2010 and 12/31/2010 as set criteria but when i add 3/3/2011</P><P>I would have to add another expression and so on - it looks like the time wizard is supposed to do this but I can't figure it out</P><P>It keeps telling me that my base expression is bad unless I use today() and even if I use today() i get no data</P><P></P><P>HELP</P><P></P><P></P></BODY></HTML> Mon, 31 Jan 2011 21:47:22 GMT 2011-01-31T21:47:22Z Comparing Time periods https://community.qlik.com/t5/QlikView/Comparing-Time-periods/m-p/302641#M1202809 <HTML><HEAD></HEAD><BODY><P>The time chart wizard is driving me crazy!!</P><P>I have the following data</P><P></P><P>Balance 200 asofdate 12/31/2010</P><P>Balance 210 asofdate 09/30/2010</P><P></P><P>I want to get 4 columns</P><P>Balance 9/30/2010 Balance 12/31/2010 Diff $ Diff%</P><P>210 200 10 5%</P><P>I know I can write 2 expressions using 9/30/2010 and 12/31/2010 as set criteria but when i add 3/3/2011</P><P>I would have to add another expression and so on - it looks like the time wizard is supposed to do this but I can't figure it out</P><P>It keeps telling me that my base expression is bad unless I use today() and even if I use today() i get no data</P><P></P><P>HELP</P><P></P><P></P></BODY></HTML> Mon, 31 Jan 2011 21:47:22 GMT https://community.qlik.com/t5/QlikView/Comparing-Time-periods/m-p/302641#M1202809 2011-01-31T21:47:22Z