topic Re: Date calculations in QlikView https://community.qlik.com/t5/QlikView/Date-calculations/m-p/825461#M290751 <HTML><HEAD></HEAD><BODY><P>Please check enclosed file showing table needed for YearMonth selection..</P><P>Same way you can create Quarter formula...</P><P></P><P>In case, user select more than one YearMonth,</P><P>change YearMonth with Max(YearMonth) in expression</P></BODY></HTML> Sat, 13 Dec 2014 07:44:37 GMT MK_QSL 2014-12-13T07:44:37Z Date calculations https://community.qlik.com/t5/QlikView/Date-calculations/m-p/825459#M290749 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i have a requirement</P><P>i need to show 4months before data when i select month in straight table, if nothing is selected should show all data</P><P>i need same solution for weeks and quarters</P><P>please help</P><P></P><P></P><P>Thank you</P></BODY></HTML> Sat, 13 Dec 2014 07:27:43 GMT https://community.qlik.com/t5/QlikView/Date-calculations/m-p/825459#M290749 2014-12-13T07:27:43Z Re: Date calculations https://community.qlik.com/t5/QlikView/Date-calculations/m-p/825460#M290750 <HTML><HEAD></HEAD><BODY><P>see this example</P></BODY></HTML> Sat, 13 Dec 2014 07:34:04 GMT https://community.qlik.com/t5/QlikView/Date-calculations/m-p/825460#M290750 ecolomer 2014-12-13T07:34:04Z Re: Date calculations https://community.qlik.com/t5/QlikView/Date-calculations/m-p/825461#M290751 <HTML><HEAD></HEAD><BODY><P>Please check enclosed file showing table needed for YearMonth selection..</P><P>Same way you can create Quarter formula...</P><P></P><P>In case, user select more than one YearMonth,</P><P>change YearMonth with Max(YearMonth) in expression</P></BODY></HTML> Sat, 13 Dec 2014 07:44:37 GMT https://community.qlik.com/t5/QlikView/Date-calculations/m-p/825461#M290751 MK_QSL 2014-12-13T07:44:37Z Re: Date calculations https://community.qlik.com/t5/QlikView/Date-calculations/m-p/825462#M290752 <HTML><HEAD></HEAD><BODY><P>Thanks Enrique Colomer</P><P></P><P>Can you prove solution for below</P><P></P><P>1. i need to show 4weeks before data when i select week in straight table, if nothing is selected should show all</P><P>2. i need to show 4 Quarters before data when i select Quarter in straight table, if nothing is selected should show all</P></BODY></HTML> Sat, 13 Dec 2014 07:45:36 GMT https://community.qlik.com/t5/QlikView/Date-calculations/m-p/825462#M290752 2014-12-13T07:45:36Z Re: Date calculations https://community.qlik.com/t5/QlikView/Date-calculations/m-p/825463#M290753 <HTML><HEAD></HEAD><BODY><P>The examples I attached below runs with yours requeiriments</P></BODY></HTML> Sat, 13 Dec 2014 07:48:45 GMT https://community.qlik.com/t5/QlikView/Date-calculations/m-p/825463#M290753 ecolomer 2014-12-13T07:48:45Z