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_]

Hey Beck,

Check this out.

[beck_bakytbek]

Hi Thiago,

thanks a lot for your example, it does make me more sure to find the solution, as you see in app: it was an example, i want to ask you, what would you do (or how would you do) if you have an master calender with years, month to concatenate with field: Finished_On, do you have any idea?

Thanks a lot

[Thiago_Justen_]

Maybe  this could be useful on it:

MakeDate(text(left(Time,4),text(right(Time,2)),1)

Obviously, if I understood exactly what you want to.

[beck_bakytbek]

Hi Thiago,

Thanks a lot for your responce and your valueable time

i try to accomplish my issue and will let you know, when i finished and show the output, ok

[Thiago_Justen_]

Sound's good Beck. I'll be right here if you need again.

Cheers

[beck_bakytbek]

Thiago, thanks again for your help and your time

[beck_bakytbek]

Hi Thiago,

i attached my example -app with explanation. Do you have any idea?

Thanks a lot

Beck

[Thiago_Justen_]

Let me see. Just a minute and I'll come back with any suggestion.

[Thiago_Justen_]

Wich extension are you using on it?

[beck_bakytbek]

Hi Thiago, i dont use any extensions, i wanted to know, is that possible to make the table selectable ( i mean if i create the table with input like aktiv and nonaktive and make the table visible like in my example-app).

Do you have any ideas?

Thanks a lot

Beck