Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
danosoft
Creator III
Creator III

Set Analisys in a chart with diff to date

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

1 Solution

Accepted Solutions
danosoft
Creator III
Creator III
Author

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))

View solution in original post

2 Replies
Brett_Bleess
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
danosoft
Creator III
Creator III
Author

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))

View solution in original post