topic Re: Date in QlikView https://community.qlik.com/t5/QlikView/Date/m-p/1387140#M815772 <HTML><HEAD></HEAD><BODY><P>Like this???</P></BODY></HTML> Mon, 11 Sep 2017 05:36:42 GMT prma7799 2017-09-11T05:36:42Z Date https://community.qlik.com/t5/QlikView/Date/m-p/1387136#M815768 <HTML><HEAD></HEAD><BODY><P>HI All ,</P><P>Please find the attachment of the qwv file .</P><P>I have a field called date .</P><P>I want to create a field which has 45 days and one more field of 120 days ...</P><P>How can i achieve this ?</P><P></P><P>Tahnks in advance </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Date/m-p/1387136#M815768 smilingjohn 2020-11-25T16:16:04Z Re: Date https://community.qlik.com/t5/QlikView/Date/m-p/1387137#M815769 <HTML><HEAD></HEAD><BODY><P>How you are expecting?</P></BODY></HTML> Mon, 11 Sep 2017 05:25:23 GMT https://community.qlik.com/t5/QlikView/Date/m-p/1387137#M815769 Anil_Babu_Samineni 2017-09-11T05:25:23Z Re: Date https://community.qlik.com/t5/QlikView/Date/m-p/1387138#M815770 <HTML><HEAD></HEAD><BODY><P>Hi Anil,</P><P>I want to it in a variable ...or in a filter </P></BODY></HTML> Mon, 11 Sep 2017 05:31:55 GMT https://community.qlik.com/t5/QlikView/Date/m-p/1387138#M815770 smilingjohn 2017-09-11T05:31:55Z Re: Date https://community.qlik.com/t5/QlikView/Date/m-p/1387139#M815771 <HTML><HEAD></HEAD><BODY><P>Still not understandable. But for a while try these?</P><P></P><P>=If(Day(Date) &lt;= 45, Dual('45 Days',1), If(Date(Date)&lt;=120, Dual('120 Days',2)))</P><P>OR</P><P>=If(Day(Date)&gt;= 0 and Day(Date) &lt;= 45, '45 Days', If(Day(Date) &gt;=46 and Day(Date) &lt;= 120, '120 Days'))</P></BODY></HTML> Mon, 11 Sep 2017 05:35:48 GMT https://community.qlik.com/t5/QlikView/Date/m-p/1387139#M815771 Anil_Babu_Samineni 2017-09-11T05:35:48Z Re: Date https://community.qlik.com/t5/QlikView/Date/m-p/1387140#M815772 <HTML><HEAD></HEAD><BODY><P>Like this???</P></BODY></HTML> Mon, 11 Sep 2017 05:36:42 GMT https://community.qlik.com/t5/QlikView/Date/m-p/1387140#M815772 prma7799 2017-09-11T05:36:42Z