You can create two tables with a date field, one to select from date and the other to select to date.
YourDate as DateFrom
YourDate as DateTo
Then create 2 variables as follows:
And then use the following expression:
Sum(if(yourDate>=vFrom and yourDate<=vTo,yourValue,0))
The expression should be able to do with whole analysis, but I can not make it work.
When you select a DateFrom value and a DateTo value, you should display the data that is between those dates.
I hope this helps you.
The expression works only with one range of value, what I am expecting is select the ID from one range of date and looking whether that ID is turned up in another range of date.
I know that I have to write a set analysis inside the set analysis. I have attached the data and App in this discussion.
Please help I have no I idea how to write the expression and let me learn.