Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
i goit a following situation, my table does look like:
Project | TimeOn | Typ | Budget |
A | 01.01.2018 | AA | 100 |
B | 31.12.2017 | BB | 150 |
C | 31.11.2017 | CC | 30 |
D | 31.09.2017 | CC | 60 |
and i use as timefilter, that i created on base of master calender the following filter:
Timefilter |
2017 11 |
2017 10 |
2017 09 |
2017 08 |
and i use the following set expression to calculate the budget for every typ of project:
Budget: | |
Sum({<Typ = {'AA'}>}Budget) | 100 |
Sum({<Typ = {'BB'}>}Budget) | 150 |
Sum({<Typ = {'CC'}>}Budget) | 90 |
everything does work great, now i have a question: lets imagine, my reportdate is:
2017 11 and if i select the date in Timefilter: 2017 11 , then should appear only two project:
Project | TimeOn | Typ | Budget |
A | 01.01.2018 | AA | 100 |
B | 31.12.2017 | BB | 150 |
because my timefilter-date: 2017 11 is lower then 01.01.2018 and 31.12.2017
and if select as reporting date 2017 10 then shoudl appear the following projects:
Project | TimeOn | Typ | Budget |
A | 01.01.2018 | AA | 100 |
B | 31.12.2017 | BB | 150 |
C | 31.11.2017 | CC | 30 |
because my timefilter-date: 2017 10 is lower then 01.01.2018, 31.12.2017 and 31.11.2017
Does have anybody any idea how to handle dynamic this issue with the helps of set expression?
Thanks a lot
Beck
Edited
Here it is. You can make wherever modification you want to.
up
Beck,
Any news about that?
Hi Thiago,
first of all thanks a lot for your feedback and help, i am today again in my office and start with your example. during this day i report you when i have any results. Ok
Hi Thiaga,
thanks a lot for your example, i have a question: how can concatenate the field: TimeOn with my MasterCalendar
I don't understand you...could you explain a little bit more?
Hi Thiago,
thanks for your responce, my customer foget to say me that we have to generate the filter as active and not active project:
if i make selection in filter: Active Project then i have my table with data, then i should make the selection in Time_Filter, and when i made selection in two filters: 1) active Projects, 2) Time then i have the table with data, it is ok Thiago, or should i create an example in qvf?
Thanks a lot
I really apreciatte if you give me an example app.
ok, give me one minute
Hi Thiago, this is my app with explanation, please let me know, if my explanation is not clear enough. thanks a lot