topic Calculated Dimension in QlikView https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/909721#M315894 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a table that calculates the total orders. The dimension is week, but unfortunately I have a problem. For present year the calculationare ok, but there are some orders made last week of 2014 that was the first of 2015, and in the table appears weeks from 1 to 30 and data from 51 week!</P><P></P><P>I wold like to fix this issue doing a calculated dimension that has a conditional: only shows weeks lower than present week.</P><P></P><P>Any idea?</P><P></P><P>Many thank's guys</P><P></P><P>Eduard</P></BODY></HTML> Wed, 22 Jul 2015 11:29:33 GMT ecabanas 2015-07-22T11:29:33Z Calculated Dimension https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/909721#M315894 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a table that calculates the total orders. The dimension is week, but unfortunately I have a problem. For present year the calculationare ok, but there are some orders made last week of 2014 that was the first of 2015, and in the table appears weeks from 1 to 30 and data from 51 week!</P><P></P><P>I wold like to fix this issue doing a calculated dimension that has a conditional: only shows weeks lower than present week.</P><P></P><P>Any idea?</P><P></P><P>Many thank's guys</P><P></P><P>Eduard</P></BODY></HTML> Wed, 22 Jul 2015 11:29:33 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/909721#M315894 ecabanas 2015-07-22T11:29:33Z Re: Calculated Dimension https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/909722#M315895 <HTML><HEAD></HEAD><BODY><P>Please post some sample data or application</P></BODY></HTML> Wed, 22 Jul 2015 11:46:25 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/909722#M315895 sasiparupudi1 2015-07-22T11:46:25Z Re: Calculated Dimension https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/909723#M315896 <HTML><HEAD></HEAD><BODY><P>See attached the !qvw</P><P></P><P></P><P>Thanks</P></BODY></HTML> Wed, 22 Jul 2015 13:03:22 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/909723#M315896 ecabanas 2015-07-22T13:03:22Z Re: Calculated Dimension https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/909724#M315897 <HTML><HEAD></HEAD><BODY><P>Either you create Week using <STRONG>LunarWeekName </STRONG>fuction&nbsp; or use calculated dimension as below</P><P></P><P>=if(date_Week&lt;= week(Today()),date_Week)</P></BODY></HTML> Wed, 22 Jul 2015 13:23:32 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/909724#M315897 Kushal_Chawda 2015-07-22T13:23:32Z