topic Need Help On Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Need-Help-On-Set-Analysis/m-p/309171#M498803 <HTML><HEAD></HEAD><BODY><P>Hi,<BR />For example:<SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal"></P><P>YTD</P><P class="MsoNormal" style="margin: 0cm 0cm 0pt;"><SPAN style="mso-bidi-font-family: Calibri; color: black; font-size: 12pt; mso-ascii-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: Calibri; font-family: Calibri; mso-bidi-theme-font: minor-latin;">sum({$&lt;Date = {"&gt;=$(=yearstart(ltoday()))&lt;=$(=today()))"}, Year = , Month = , Day = &gt;} amount)</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"><BR /></SPAN>MTD</P><P><BR /><SPAN style="mso-bidi-font-family: Calibri; color: black; font-size: 12pt; mso-ascii-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: Calibri; font-family: Calibri; mso-bidi-theme-font: minor-latin;">sum({$&lt;Date = {"&gt;=$(=monthstart(ltoday()))&lt;=$(=today()))"}, Year = , Month = , Day = &gt;} amount)<BR /></SPAN></P><P></P><P>/@Ungvall</P></BODY></HTML> Wed, 22 Jun 2011 06:55:23 GMT 2011-06-22T06:55:23Z Need Help On Set Analysis https://community.qlik.com/t5/QlikView/Need-Help-On-Set-Analysis/m-p/309170#M498802 <HTML><HEAD></HEAD><BODY><P style="margin-bottom: 10px;">Hi All,</P><P></P><P></P><P style="margin-bottom: 10px;">I need a help, actually I need a set analysis for YTD and MTD without using "inyeartodate" and "inmonthtodate" for current and previous financial year</P><P style="margin-bottom: 10px;">.</P><P style="margin-bottom: 10px;">Its urgent.</P><P></P><P style="margin-bottom: 10px;">Kindly reply ASAP</P><P></P><P></P><P style="margin-bottom: 10px;">Regards</P><P style="margin-bottom: 10px;">Neetu Singh</P></BODY></HTML> Wed, 22 Jun 2011 06:16:48 GMT https://community.qlik.com/t5/QlikView/Need-Help-On-Set-Analysis/m-p/309170#M498802 neetu_singh 2011-06-22T06:16:48Z Need Help On Set Analysis https://community.qlik.com/t5/QlikView/Need-Help-On-Set-Analysis/m-p/309171#M498803 <HTML><HEAD></HEAD><BODY><P>Hi,<BR />For example:<SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P class="MsoNormal"></P><P>YTD</P><P class="MsoNormal" style="margin: 0cm 0cm 0pt;"><SPAN style="mso-bidi-font-family: Calibri; color: black; font-size: 12pt; mso-ascii-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: Calibri; font-family: Calibri; mso-bidi-theme-font: minor-latin;">sum({$&lt;Date = {"&gt;=$(=yearstart(ltoday()))&lt;=$(=today()))"}, Year = , Month = , Day = &gt;} amount)</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"><BR /></SPAN>MTD</P><P><BR /><SPAN style="mso-bidi-font-family: Calibri; color: black; font-size: 12pt; mso-ascii-font-family: Calibri; mso-hansi-theme-font: minor-latin; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-hansi-font-family: Calibri; font-family: Calibri; mso-bidi-theme-font: minor-latin;">sum({$&lt;Date = {"&gt;=$(=monthstart(ltoday()))&lt;=$(=today()))"}, Year = , Month = , Day = &gt;} amount)<BR /></SPAN></P><P></P><P>/@Ungvall</P></BODY></HTML> Wed, 22 Jun 2011 06:55:23 GMT https://community.qlik.com/t5/QlikView/Need-Help-On-Set-Analysis/m-p/309171#M498803 2011-06-22T06:55:23Z