topic Comparing variables with different time dimensions in QlikView https://community.qlik.com/t5/QlikView/Comparing-variables-with-different-time-dimensions/m-p/252172#M1206347 <HTML><HEAD></HEAD><BODY><P>Hello Johan,</P><P>I would recommend you to create a Master Calendar so you will have all your dates in the same dimension, an easier to query.</P><P>There are a lot of posts in the forum about how to get it done, but you can use <A href="http://community.qlik.com/forums/p/22821/87243.aspx" title="How to make a calendar?">this post</A> and <A href="http://community.qlik.com/wikis/qlikview-wiki/how-to-create-a-calendar.aspx" title="How to create a Calendar">this wiki</A>.</P><P>Regards.</P></BODY></HTML> Mon, 19 Apr 2010 11:00:32 GMT Miguel_Angel_Baeyens 2010-04-19T11:00:32Z Comparing variables with different time dimensions https://community.qlik.com/t5/QlikView/Comparing-variables-with-different-time-dimensions/m-p/252170#M1206345 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P>I am having problems with comparing variables that have different time dimensions.</P><P>I am trying to divide the sum of one variable X with the sum of another Y over time. But one of them have X.year and the other one have Y.year so I can not use the same time variable since they are not both connected to it.</P><P>Please help me out</P><P>/Johan</P></BODY></HTML> Mon, 19 Apr 2010 09:41:58 GMT https://community.qlik.com/t5/QlikView/Comparing-variables-with-different-time-dimensions/m-p/252170#M1206345 2010-04-19T09:41:58Z Comparing variables with different time dimensions https://community.qlik.com/t5/QlikView/Comparing-variables-with-different-time-dimensions/m-p/252171#M1206346 <HTML><HEAD></HEAD><BODY><P>Hi Johan,</P><P>Can you provide more details about the issue.</P><P>Regards</P><P>Rajesh</P></BODY></HTML> Mon, 19 Apr 2010 10:46:48 GMT https://community.qlik.com/t5/QlikView/Comparing-variables-with-different-time-dimensions/m-p/252171#M1206346 2010-04-19T10:46:48Z Comparing variables with different time dimensions https://community.qlik.com/t5/QlikView/Comparing-variables-with-different-time-dimensions/m-p/252172#M1206347 <HTML><HEAD></HEAD><BODY><P>Hello Johan,</P><P>I would recommend you to create a Master Calendar so you will have all your dates in the same dimension, an easier to query.</P><P>There are a lot of posts in the forum about how to get it done, but you can use <A href="http://community.qlik.com/forums/p/22821/87243.aspx" title="How to make a calendar?">this post</A> and <A href="http://community.qlik.com/wikis/qlikview-wiki/how-to-create-a-calendar.aspx" title="How to create a Calendar">this wiki</A>.</P><P>Regards.</P></BODY></HTML> Mon, 19 Apr 2010 11:00:32 GMT https://community.qlik.com/t5/QlikView/Comparing-variables-with-different-time-dimensions/m-p/252172#M1206347 Miguel_Angel_Baeyens 2010-04-19T11:00:32Z