topic Re: How to get data with in date range? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-data-with-in-date-range/m-p/707373#M1081299 <HTML><HEAD></HEAD><BODY><P>Use Distinct ID</P></BODY></HTML> Thu, 03 Jul 2014 14:49:22 GMT MK_QSL 2014-07-03T14:49:22Z How to get data with in date range? https://community.qlik.com/t5/QlikView/How-to-get-data-with-in-date-range/m-p/707370#M1081296 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>I have table with below details</P><P></P><P>Dimension: Member</P><P>Expression: =Count({&lt;Date={"&gt;=$(WeekStart(today())-7))&lt;=$(Weekend(today())-8)"},Tailors={'Open','open'}&gt;}ID)</P><P></P><P>The data should show the count of ID between 23/06/2014 and 27/06/2014 for open tailors. The table is showing incorrect data. Can anyone suggest me do I need to make any changes in expression?</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 03 Jul 2014 14:40:16 GMT https://community.qlik.com/t5/QlikView/How-to-get-data-with-in-date-range/m-p/707370#M1081296 2014-07-03T14:40:16Z Re: How to get data with in date range? https://community.qlik.com/t5/QlikView/How-to-get-data-with-in-date-range/m-p/707371#M1081297 <HTML><HEAD></HEAD><BODY><P>=Count({&lt;Date={"&gt;=$(=Date(WeekStart(Today())-7))&lt;=$(Date(WeekEnd(Today())-7))"},Tailors={'Open','open'}&gt;}ID)</P><P></P><P>Change 7 to 8 as per your date requirements...</P></BODY></HTML> Thu, 03 Jul 2014 14:46:46 GMT https://community.qlik.com/t5/QlikView/How-to-get-data-with-in-date-range/m-p/707371#M1081297 MK_QSL 2014-07-03T14:46:46Z Re: How to get data with in date range? https://community.qlik.com/t5/QlikView/How-to-get-data-with-in-date-range/m-p/707372#M1081298 <HTML><HEAD></HEAD><BODY><P>Thanks. I tried it. It is showing count more when compared to database records.</P></BODY></HTML> Thu, 03 Jul 2014 14:48:53 GMT https://community.qlik.com/t5/QlikView/How-to-get-data-with-in-date-range/m-p/707372#M1081298 2014-07-03T14:48:53Z Re: How to get data with in date range? https://community.qlik.com/t5/QlikView/How-to-get-data-with-in-date-range/m-p/707373#M1081299 <HTML><HEAD></HEAD><BODY><P>Use Distinct ID</P></BODY></HTML> Thu, 03 Jul 2014 14:49:22 GMT https://community.qlik.com/t5/QlikView/How-to-get-data-with-in-date-range/m-p/707373#M1081299 MK_QSL 2014-07-03T14:49:22Z Re: How to get data with in date range? https://community.qlik.com/t5/QlikView/How-to-get-data-with-in-date-range/m-p/707374#M1081300 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Try some thing like this</P><P></P><P><STRONG>=Count( DISTINCT {&lt;Date={"&gt;=$(=Date(floor((WeekStart(Today())-7)))&lt;=$(Date(floor(WeekEnd(Today())-7)))"},</STRONG></P><P><STRONG>Tailors={'Open','open'}&gt;}ID)</STRONG></P></BODY></HTML> Thu, 03 Jul 2014 14:52:17 GMT https://community.qlik.com/t5/QlikView/How-to-get-data-with-in-date-range/m-p/707374#M1081300 sasikanth 2014-07-03T14:52:17Z Re: How to get data with in date range? https://community.qlik.com/t5/QlikView/How-to-get-data-with-in-date-range/m-p/707375#M1081301 <HTML><HEAD></HEAD><BODY><P>Same count getting. I created two variables from and to</P><P></P><P>From = =WeekStart(today()-7)</P><P>To= =Date(WeekEnd(today()-5)-1,'DD/MM/YYYY')</P><P></P><P>I used button 'Apply' with these and the data is showing correct.</P><P></P><P>But I would need to show the data with expression instead of variables. Is that possible?</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 03 Jul 2014 14:52:41 GMT https://community.qlik.com/t5/QlikView/How-to-get-data-with-in-date-range/m-p/707375#M1081301 2014-07-03T14:52:41Z Re: How to get data with in date range? https://community.qlik.com/t5/QlikView/How-to-get-data-with-in-date-range/m-p/707376#M1081302 <HTML><HEAD></HEAD><BODY><P>Thanks. tried. showing all blank values. do I need to change anything?</P></BODY></HTML> Thu, 03 Jul 2014 14:54:28 GMT https://community.qlik.com/t5/QlikView/How-to-get-data-with-in-date-range/m-p/707376#M1081302 2014-07-03T14:54:28Z Re: How to get data with in date range? https://community.qlik.com/t5/QlikView/How-to-get-data-with-in-date-range/m-p/707377#M1081303 <HTML><HEAD></HEAD><BODY><P>The expression was missing an = sign:</P><P></P><P>Count({&lt;Date={"&gt;=$(=Date(WeekStart(Today(1))-7)) &lt;=$(=Date(WeekEnd(Today(1))-7))"}, Tailors={'Open','open'}&gt;} ID)</P><P></P><P>Jonathan</P></BODY></HTML> Thu, 03 Jul 2014 14:55:44 GMT https://community.qlik.com/t5/QlikView/How-to-get-data-with-in-date-range/m-p/707377#M1081303 jonathandienst 2014-07-03T14:55:44Z Re: How to get data with in date range? https://community.qlik.com/t5/QlikView/How-to-get-data-with-in-date-range/m-p/707378#M1081304 <HTML><HEAD></HEAD><BODY><P>Thanks. near to result. getting extra 4 values. Actually the count is 460. but it is showing 464. Any change please.</P></BODY></HTML> Thu, 03 Jul 2014 15:02:53 GMT https://community.qlik.com/t5/QlikView/How-to-get-data-with-in-date-range/m-p/707378#M1081304 2014-07-03T15:02:53Z Re: How to get data with in date range? https://community.qlik.com/t5/QlikView/How-to-get-data-with-in-date-range/m-p/707379#M1081305 <HTML><HEAD></HEAD><BODY><P>Provide sample data</P></BODY></HTML> Thu, 03 Jul 2014 15:04:47 GMT https://community.qlik.com/t5/QlikView/How-to-get-data-with-in-date-range/m-p/707379#M1081305 MK_QSL 2014-07-03T15:04:47Z