https://community.qlik.com/t5/QlikView/Set-Analisys-in-a-chart-with-diff-to-date/m-p/1610622#M507784 <P>Hi i have this set analisys in my chart:</P><P>Sum(DISTINCT {&lt;DATA_IN={"=Aggr(Max(DATA_IN), MESEIN, COD_PUNTO)"}&gt;} CONSUMO_TOT_ANNUO)</P><P>i need to put a filter in that set analisys where the different from DATA_OUT - DATA_IN is &gt; 2</P><P>how can i do that?</P><P>thanks</P> Thu, 08 Aug 2019 10:59:14 GMT danosoft 2019-08-08T10:59:14Z https://community.qlik.com/t5/QlikView/Set-Analisys-in-a-chart-with-diff-to-date/m-p/1610622#M507784 <P>Hi i have this set analisys in my chart:</P><P>Sum(DISTINCT {&lt;DATA_IN={"=Aggr(Max(DATA_IN), MESEIN, COD_PUNTO)"}&gt;} CONSUMO_TOT_ANNUO)</P><P>i need to put a filter in that set analisys where the different from DATA_OUT - DATA_IN is &gt; 2</P><P>how can i do that?</P><P>thanks</P> Thu, 08 Aug 2019 10:59:14 GMT https://community.qlik.com/t5/QlikView/Set-Analisys-in-a-chart-with-diff-to-date/m-p/1610622#M507784 danosoft 2019-08-08T10:59:14Z https://community.qlik.com/t5/QlikView/Set-Analisys-in-a-chart-with-diff-to-date/m-p/1617071#M507785 <P>Daniele, best I have for you is the following, hopefully will allow you to make some progress if you have not already...</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344</A></P> <P>There are some additional links in the above blog post, just FYI, and I am also including the Help site link too just to cover all the bases for you:</P> <P><A href="https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-analysis-expressions.htm" target="_blank">https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-analysis-expressions.htm</A></P> <P>Regards,<BR />Brett</P> Tue, 27 Aug 2019 12:47:00 GMT https://community.qlik.com/t5/QlikView/Set-Analisys-in-a-chart-with-diff-to-date/m-p/1617071#M507785 Brett_Bleess 2019-08-27T12:47:00Z https://community.qlik.com/t5/QlikView/Set-Analisys-in-a-chart-with-diff-to-date/m-p/1617074#M507786 <P>Hi, thanks for reply but i find from myself, this is the right answer:</P><P>&nbsp;</P><P>Sum(DISTINCT {&lt;DATA_IN={"=Aggr(Max(DATA_IN), MESEIN, COD_PUNTO)"}&gt;}<STRONG>if(Num(Interval(DATA_OUT-DATA_IN,'DD'))&gt;2</STRONG>, CONSUMO_TOT_ANNUO))</P> Tue, 27 Aug 2019 12:53:03 GMT https://community.qlik.com/t5/QlikView/Set-Analisys-in-a-chart-with-diff-to-date/m-p/1617074#M507786 danosoft 2019-08-27T12:53:03Z