topic Set Analysis - YTD sales for current Hijri Year in App Development https://community.qlik.com/t5/App-Development/Set-Analysis-YTD-sales-for-current-Hijri-Year/m-p/1428220#M34176 <HTML><HEAD></HEAD><BODY><P>I have a master calendar which has the below values :</P><P></P><P>Date</P><P>Year</P><P>Month Year</P><P>Hijri Date</P><P>Hijri Year</P><P>Hijri Month Year</P><P></P><P>I can calculate the current year sales as below:</P><P></P><P><SPAN style="font-size: 10pt;">Sum({$&lt;[Date] = {"&lt;=$(=Today()-1)"},[Year]={"$(=Year(Today()))"}&nbsp; [Sales])</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">I have a requirement to produce current Hijri Year sales. How can i write a similar set analysis function as above for it?</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P></BODY></HTML> Sun, 17 Sep 2017 10:40:15 GMT madnanansari 2017-09-17T10:40:15Z Set Analysis - YTD sales for current Hijri Year https://community.qlik.com/t5/App-Development/Set-Analysis-YTD-sales-for-current-Hijri-Year/m-p/1428220#M34176 <HTML><HEAD></HEAD><BODY><P>I have a master calendar which has the below values :</P><P></P><P>Date</P><P>Year</P><P>Month Year</P><P>Hijri Date</P><P>Hijri Year</P><P>Hijri Month Year</P><P></P><P>I can calculate the current year sales as below:</P><P></P><P><SPAN style="font-size: 10pt;">Sum({$&lt;[Date] = {"&lt;=$(=Today()-1)"},[Year]={"$(=Year(Today()))"}&nbsp; [Sales])</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">I have a requirement to produce current Hijri Year sales. How can i write a similar set analysis function as above for it?</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P></BODY></HTML> Sun, 17 Sep 2017 10:40:15 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-YTD-sales-for-current-Hijri-Year/m-p/1428220#M34176 madnanansari 2017-09-17T10:40:15Z