Set Analisys in a chart with diff to date

[danosoft]

Hi i have this set analisys in my chart:

Sum(DISTINCT {<DATA_IN={"=Aggr(Max(DATA_IN), MESEIN, COD_PUNTO)"}>} CONSUMO_TOT_ANNUO)

i need to put a filter in that set analisys where the different from DATA_OUT - DATA_IN is > 2

how can i do that?

thanks

[Brett_Bleess]

Daniele, best I have for you is the following, hopefully will allow you to make some progress if you have not already...

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

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:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

Regards,
Brett

[danosoft · Accepted solution]

Hi, thanks for reply but i find from myself, this is the right answer:

Sum(DISTINCT {<DATA_IN={"=Aggr(Max(DATA_IN), MESEIN, COD_PUNTO)"}>}if(Num(Interval(DATA_OUT-DATA_IN,'DD'))>2, CONSUMO_TOT_ANNUO))