topic Calculating data onlast weekend in QlikView https://community.qlik.com/t5/QlikView/Calculating-data-onlast-weekend/m-p/328329#M120870 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am new to qlikview.</P><P>My requirement is that I wish to show data in a chart for current date as well as data on date of last weekend.</P><P>I can show easily data for current date, but how to calculate data for last weekend?</P><P>I am having personal edition of qlikview so can't open any external files.</P><P>Can anyone please paste here function?</P><P>Thanks in advance.</P></BODY></HTML> Wed, 29 Jun 2011 04:27:26 GMT 2011-06-29T04:27:26Z Calculating data onlast weekend https://community.qlik.com/t5/QlikView/Calculating-data-onlast-weekend/m-p/328329#M120870 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am new to qlikview.</P><P>My requirement is that I wish to show data in a chart for current date as well as data on date of last weekend.</P><P>I can show easily data for current date, but how to calculate data for last weekend?</P><P>I am having personal edition of qlikview so can't open any external files.</P><P>Can anyone please paste here function?</P><P>Thanks in advance.</P></BODY></HTML> Wed, 29 Jun 2011 04:27:26 GMT https://community.qlik.com/t5/QlikView/Calculating-data-onlast-weekend/m-p/328329#M120870 2011-06-29T04:27:26Z Calculating data onlast weekend https://community.qlik.com/t5/QlikView/Calculating-data-onlast-weekend/m-p/328330#M120871 <HTML><HEAD></HEAD><BODY><P>You will likely want to use either some if() statements or Set Analysis for your calculation, but the function you are looking for would be something like: =num(weekday(Datefield)) which will return a value between 0-6. 5 &amp; 6 being Saturday &amp; Sunday. </P></BODY></HTML> Wed, 29 Jun 2011 05:42:30 GMT https://community.qlik.com/t5/QlikView/Calculating-data-onlast-weekend/m-p/328330#M120871 2011-06-29T05:42:30Z Re: Calculating data onlast weekend https://community.qlik.com/t5/QlikView/Calculating-data-onlast-weekend/m-p/328331#M120872 <HTML><HEAD></HEAD><BODY><P>Can anyone please paste here code to calculate sum(orders) on last weekend (of max(date)) with respect to max(date)?</P><P>my date is in yyyy-mm-dd format</P></BODY></HTML> Wed, 29 Jun 2011 06:31:39 GMT https://community.qlik.com/t5/QlikView/Calculating-data-onlast-weekend/m-p/328331#M120872 2011-06-29T06:31:39Z