Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
beck_bakytbek
Master
Master

Dynamic time expression-selection

Hi Folks,

i goit a following situation, my table does look like:

ProjectTimeOnTypBudget
A01.01.2018AA100
B31.12.2017BB150
C31.11.2017CC30
D31.09.2017CC60

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:

  

ProjectTimeOnTypBudget
A01.01.2018AA100
B31.12.2017BB

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:

  

ProjectTimeOnTypBudget
A01.01.2018AA100
B31.12.2017BB150
C31.11.2017CC30

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

1 Solution

Accepted Solutions
Thiago_Justen_

Check this app. Please, install the extension to see full customization aplied.

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago

View solution in original post

43 Replies
YoussefBelloum
Champion
Champion

Hi,

report.png

I'm missing something here, how you can you display projects with dates (01.01.2018 and 31.12.2017) when selecting the date 2017.11 ?

With the data set you mentioned above, I think you will only have the Project C displayed when selecting date 2017.01

beck_bakytbek
Master
Master
Author

Hi youssef,

first of all, thanks a lot for your responce:

the column TimeOn consists the Data as concluded Date of each project and the timefilter i have built on the base of master calender

YoussefBelloum
Champion
Champion

can you describe more how you want it to be dynamic ?

try to describe the usecase.

OmarBenSalem

maybe sthing like;

sum({<YearField=,MonthField=, TimeOn={">=$(=max(date(date#(Timefilter,'YYYY MM'),'YYYY.MM.DD')))"}>}Measure)

beck_bakytbek
Master
Master
Author

Hi youssef thanks a lot for your responce,

my usecase is:

if i select in timefilter the date: 2017 11 then shoul appear only two projects: A and B, because the Project A has 01.01.2018 and the Project B  has 31.12.2017 in Column TimeOn.

2017 11 is lower then 01.01.2018 and 31.12.2017

beck_bakytbek
Master
Master
Author

Hi Omar,

thanks a lot for your responce, i will try to implement it and will report you

beck_bakytbek
Master
Master
Author

Hi Omar,

thanks a lot, i tried  but it does not work, i think, i explained not enough clear, my customer says to me, we have only active projects, my table does look like;

ProjectTimeOnTypBudget
A01.01.2018AA100
B31.12.2017BB150
C31.11.2017CC30
D31.09.2017CC60

if i select on my timefilter

30.11.2017 then i should see

ProjectTimeOnTypBudget
A01.01.2018AA100
B31.12.2017BB

150

my problem is, i should ask my customer, what does he mean with active projects and when i solved this question, i would like to know how to create the set expression with timeexpression, do you have any idea?

thanks a lot

Beck

Thiago_Justen_

Hey Beck,

Is this what you want to?

Capturar.PNG

Cheers

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago
beck_bakytbek
Master
Master
Author

Hi Thiago,

it does look good, do you have an example - qfv?

i make my selection in timefilter, do you have a dependence with timefilter?