topic Re: how to get data on current week? in QlikView https://community.qlik.com/t5/QlikView/how-to-get-data-on-current-week/m-p/688366#M1083001 <HTML><HEAD></HEAD><BODY><P>yes thats correct</P></BODY></HTML> Tue, 01 Jul 2014 14:45:56 GMT SunilChauhan 2014-07-01T14:45:56Z how to get data on current week? https://community.qlik.com/t5/QlikView/how-to-get-data-on-current-week/m-p/688362#M1082997 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have to show the no of salesitems logged and no of salesitems closed in current week, i,e if user access the file on every Thursday user need to show the data from Monday to Thursday for eg: if I logged on 03/07/2014 the table will show the data from 30/06/2014 to 03/07/2014.</P><P></P><P>Is it possible. can anyone help me with expression?</P><P></P><P>I used below but not getting how to change on week.</P><P></P><P>Dimension: staff<BR />Dimension: Product</P><P>expression1: count(distinct(Saleid)<BR />Expression2: =Count({&lt;growns={'Closed','closed'}&gt;}Saleid)</P></BODY></HTML> Tue, 01 Jul 2014 14:11:16 GMT https://community.qlik.com/t5/QlikView/how-to-get-data-on-current-week/m-p/688362#M1082997 2014-07-01T14:11:16Z Re: how to get data on current week? https://community.qlik.com/t5/QlikView/how-to-get-data-on-current-week/m-p/688363#M1082998 <HTML><HEAD></HEAD><BODY><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #00b050; font-size: 10pt;">Maybe:</SPAN></P><P><SPAN lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #00b050; font-size: 10pt;">Week = {$(=Max(Week))</SPAN></P></BODY></HTML> Tue, 01 Jul 2014 14:21:47 GMT https://community.qlik.com/t5/QlikView/how-to-get-data-on-current-week/m-p/688363#M1082998 2014-07-01T14:21:47Z Re: how to get data on current week? https://community.qlik.com/t5/QlikView/how-to-get-data-on-current-week/m-p/688364#M1082999 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Count({&lt;Date={"&gt;=$(=Weekstart(today()))&lt;=<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">$(=Weekend(today())-3)"</SPAN>&nbsp;&nbsp;&nbsp; },growns={'Closed','closed'}&gt;}Saleid)</SPAN></P></BODY></HTML> Tue, 01 Jul 2014 14:24:56 GMT https://community.qlik.com/t5/QlikView/how-to-get-data-on-current-week/m-p/688364#M1082999 SunilChauhan 2014-07-01T14:24:56Z Re: how to get data on current week? https://community.qlik.com/t5/QlikView/how-to-get-data-on-current-week/m-p/688365#M1083000 <HTML><HEAD></HEAD><BODY><P>Thanks. for logged I can use below right?</P><P></P><P></P><P><SPAN style="font-size: 8pt;">Count({&lt;Date={"&gt;=$(=Weekstart(today()))&lt;=$(=Weekend(today())-3)"&nbsp;&nbsp;&nbsp; }&gt;}saleid)<BR /> </SPAN></P><P></P></BODY></HTML> Tue, 01 Jul 2014 14:30:10 GMT https://community.qlik.com/t5/QlikView/how-to-get-data-on-current-week/m-p/688365#M1083000 2014-07-01T14:30:10Z Re: how to get data on current week? https://community.qlik.com/t5/QlikView/how-to-get-data-on-current-week/m-p/688366#M1083001 <HTML><HEAD></HEAD><BODY><P>yes thats correct</P></BODY></HTML> Tue, 01 Jul 2014 14:45:56 GMT https://community.qlik.com/t5/QlikView/how-to-get-data-on-current-week/m-p/688366#M1083001 SunilChauhan 2014-07-01T14:45:56Z Re: how to get data on current week? https://community.qlik.com/t5/QlikView/how-to-get-data-on-current-week/m-p/688367#M1083002 <HTML><HEAD></HEAD><BODY><P>Thanks.</P></BODY></HTML> Tue, 01 Jul 2014 14:47:46 GMT https://community.qlik.com/t5/QlikView/how-to-get-data-on-current-week/m-p/688367#M1083002 2014-07-01T14:47:46Z