topic Re: How to create expression to select data based on date range? in QlikView https://community.qlik.com/t5/QlikView/How-to-create-expression-to-select-data-based-on-date-range/m-p/825641#M1047384 <HTML><HEAD></HEAD><BODY><P><BR />Hi</P><P></P><P>Try this Here your current date is 13/11/2014 that is today.</P><P>let vcurrdate=today();</P><P></P><P>Count({$&lt;Date={'=&lt;($(vcurrdate) &gt;=(($(vcurrdate)-7))'}&gt;}&nbsp; CustomerID)</P></BODY></HTML> Thu, 13 Nov 2014 13:43:21 GMT 2014-11-13T13:43:21Z How to create expression to select data based on date range? https://community.qlik.com/t5/QlikView/How-to-create-expression-to-select-data-based-on-date-range/m-p/825639#M1047382 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>can anyone suggest me please. as I need to show data from last Week Friday to current week Thursday.</P><P></P><P>suppose today is 13/11/2014 I need to show data from 07/11/2014 to 13/11/2014. so, it should happen for any week for example if the user select data from Friday to Thursday in last month the data should change based on selection.</P><P></P><P>How can I create expression Please help</P><P></P><P>How to change below expression</P><P></P><P></P><P>Count({$&lt;DateType={'Logged'}&gt;} Distinct CustomerID)</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 13 Nov 2014 12:43:58 GMT https://community.qlik.com/t5/QlikView/How-to-create-expression-to-select-data-based-on-date-range/m-p/825639#M1047382 2014-11-13T12:43:58Z Re: How to create expression to select data based on date range? https://community.qlik.com/t5/QlikView/How-to-create-expression-to-select-data-based-on-date-range/m-p/825640#M1047383 <HTML><HEAD></HEAD><BODY><P>can anyone suggest me please</P></BODY></HTML> Thu, 13 Nov 2014 13:30:55 GMT https://community.qlik.com/t5/QlikView/How-to-create-expression-to-select-data-based-on-date-range/m-p/825640#M1047383 2014-11-13T13:30:55Z Re: How to create expression to select data based on date range? https://community.qlik.com/t5/QlikView/How-to-create-expression-to-select-data-based-on-date-range/m-p/825641#M1047384 <HTML><HEAD></HEAD><BODY><P><BR />Hi</P><P></P><P>Try this Here your current date is 13/11/2014 that is today.</P><P>let vcurrdate=today();</P><P></P><P>Count({$&lt;Date={'=&lt;($(vcurrdate) &gt;=(($(vcurrdate)-7))'}&gt;}&nbsp; CustomerID)</P></BODY></HTML> Thu, 13 Nov 2014 13:43:21 GMT https://community.qlik.com/t5/QlikView/How-to-create-expression-to-select-data-based-on-date-range/m-p/825641#M1047384 2014-11-13T13:43:21Z Re: How to create expression to select data based on date range? https://community.qlik.com/t5/QlikView/How-to-create-expression-to-select-data-based-on-date-range/m-p/825642#M1047385 <HTML><HEAD></HEAD><BODY><P>You have to write expression using "date(weekend(today())-9)" which will give you last friday and "date(weekend(today())-3)" which will give you this week thursday</P></BODY></HTML> Thu, 13 Nov 2014 14:16:38 GMT https://community.qlik.com/t5/QlikView/How-to-create-expression-to-select-data-based-on-date-range/m-p/825642#M1047385 Anonymous 2014-11-13T14:16:38Z