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

Good morning Beck,

Here is the link of the extension;

http://branch.qlik.com/#!/project/5775290349fc1bfca8047ad2

[beck_bakytbek]

Hi Thiago, thanks a lot for your help, it does look great

[beck_bakytbek]

Hi Thiago,

i have a question to another issue, i will open new issue-discussion. is that ok?

[Thiago_Justen_]

Hi Beck. Yeap, feel free to open it. I'll be wainting to help you again.