topic Set Analysis with Conditional Selections in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-with-Conditional-Selections/m-p/210938#M65352 <HTML><HEAD></HEAD><BODY><P>Try to use following expression</P><P>SUM({1&lt;InvoiceDate = {"&gt;=$(=DATE(TODAY()-366))&lt;=$(=DATE(TODAY()))"}&gt;} [LineSalesAmount])</P><P>This will sum all invoices in last 366 days.</P><P>The Number Format of the field InvoiceDate must be Date.</P></BODY></HTML> Mon, 12 Apr 2010 14:37:06 GMT d_pranskus 2010-04-12T14:37:06Z Set Analysis with Conditional Selections https://community.qlik.com/t5/QlikView/Set-Analysis-with-Conditional-Selections/m-p/210937#M65351 <HTML><HEAD></HEAD><BODY><H3>I am trying to create an expression as follows :</H3><H3>sum({1&lt;InvoiceDate = {"=($(vTodaysDate) - InvoiceDate)&lt;366"}&gt;} [LineSalesAmount]))</H3><P>1. The expression should be independent of any selections. So I added sum({1 ....</P><P>2. But the issue is I have InvoiceDate inside the condition . So this condition is afffected by the selection</P><P>The question is how can I make the condition also independent of the selection</P><P></P><P></P><P></P><BR /><BR /></BODY></HTML> Mon, 12 Apr 2010 13:15:54 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-Conditional-Selections/m-p/210937#M65351 2010-04-12T13:15:54Z Set Analysis with Conditional Selections https://community.qlik.com/t5/QlikView/Set-Analysis-with-Conditional-Selections/m-p/210938#M65352 <HTML><HEAD></HEAD><BODY><P>Try to use following expression</P><P>SUM({1&lt;InvoiceDate = {"&gt;=$(=DATE(TODAY()-366))&lt;=$(=DATE(TODAY()))"}&gt;} [LineSalesAmount])</P><P>This will sum all invoices in last 366 days.</P><P>The Number Format of the field InvoiceDate must be Date.</P></BODY></HTML> Mon, 12 Apr 2010 14:37:06 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-Conditional-Selections/m-p/210938#M65352 d_pranskus 2010-04-12T14:37:06Z