topic Set Analysis: Sum Bookmark Value with two between days in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Sum-Bookmark-Value-with-two-between-days/m-p/370250#M1174663 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P></P><P>How to sum bookmark value and two between days using set analysis.</P><P></P><P>1. Ex: SUM({<STRONG>BM02 </STRONG>&lt;SALESDATE={"&gt;=$(WEEKSTART(DATE))&lt;=$(WEEKEND(DATE))"}&gt;} SALESQTY)</P><P></P><P>As Same None Bookmark using is work</P><P></P><P>2. Ex: SUM({&lt;SALESDATE={"&gt;=$(WEEKSTART(DATE))&lt;=$(WEEKEND(DATE))"}&gt;} SALESQTY)</P><P></P><P>With Regards,</P><P>V.Muni</P></BODY></HTML> Wed, 27 Jun 2012 12:35:10 GMT muniyandi 2012-06-27T12:35:10Z Set Analysis: Sum Bookmark Value with two between days https://community.qlik.com/t5/QlikView/Set-Analysis-Sum-Bookmark-Value-with-two-between-days/m-p/370250#M1174663 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P></P><P>How to sum bookmark value and two between days using set analysis.</P><P></P><P>1. Ex: SUM({<STRONG>BM02 </STRONG>&lt;SALESDATE={"&gt;=$(WEEKSTART(DATE))&lt;=$(WEEKEND(DATE))"}&gt;} SALESQTY)</P><P></P><P>As Same None Bookmark using is work</P><P></P><P>2. Ex: SUM({&lt;SALESDATE={"&gt;=$(WEEKSTART(DATE))&lt;=$(WEEKEND(DATE))"}&gt;} SALESQTY)</P><P></P><P>With Regards,</P><P>V.Muni</P></BODY></HTML> Wed, 27 Jun 2012 12:35:10 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Sum-Bookmark-Value-with-two-between-days/m-p/370250#M1174663 muniyandi 2012-06-27T12:35:10Z Re: Set Analysis: Sum Bookmark Value with two between days https://community.qlik.com/t5/QlikView/Set-Analysis-Sum-Bookmark-Value-with-two-between-days/m-p/370251#M1174664 <HTML><HEAD></HEAD><BODY><P>Hi muni,</P><P></P><P>Muni Ur Expression is Wrong Please check thiis Expression</P><P></P><P>=SUM({BM02 &lt;SaleDate={"&gt;=$(=weekstart(Date(DATE)))&lt;=$(=weekend(Date(DATE))"}&gt;} SalesAmount)</P></BODY></HTML> Wed, 27 Jun 2012 13:21:14 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Sum-Bookmark-Value-with-two-between-days/m-p/370251#M1174664 perumal_41 2012-06-27T13:21:14Z Re: Set Analysis: Sum Bookmark Value with two between days https://community.qlik.com/t5/QlikView/Set-Analysis-Sum-Bookmark-Value-with-two-between-days/m-p/370252#M1174665 <HTML><HEAD></HEAD><BODY><P>Thankx Perumal A.</P><P></P><P>You expression is correct.</P><P></P><P>We are using variable must use = ?</P></BODY></HTML> Wed, 27 Jun 2012 13:29:40 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Sum-Bookmark-Value-with-two-between-days/m-p/370252#M1174665 muniyandi 2012-06-27T13:29:40Z Re: Set Analysis: Sum Bookmark Value with two between days https://community.qlik.com/t5/QlikView/Set-Analysis-Sum-Bookmark-Value-with-two-between-days/m-p/370253#M1174666 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>when use function inside variable&nbsp; u want to use '='&nbsp; must.</P></BODY></HTML> Wed, 27 Jun 2012 13:33:45 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Sum-Bookmark-Value-with-two-between-days/m-p/370253#M1174666 perumal_41 2012-06-27T13:33:45Z