Dynamic time expression-selection

[beck_bakytbek]

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

[Thiago_Justen_]

Edited

Here it is. You can make wherever modification you want to.

[Thiago_Justen_]

up

[Thiago_Justen_]

Beck,

Any news about that?

[beck_bakytbek]

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

[beck_bakytbek]

Hi Thiaga,

thanks a lot for your example, i have a question: how can concatenate the field: TimeOn with my MasterCalendar

[Thiago_Justen_]

I don't understand you...could you explain a little bit more?

[beck_bakytbek]

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

[Thiago_Justen_]

I really apreciatte if you give me an example app.

[beck_bakytbek]

ok, give me one minute

[beck_bakytbek]

Hi Thiago, this is my app with explanation, please let me know, if my explanation is not clear enough. thanks a lot