Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

beck110979
Valued Contributor III

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
Valued Contributor III

Re: Dynamic time expression-selection

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

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
43 Replies
YoussefBelloum
Esteemed Contributor

Re: Dynamic time expression-selection

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

beck110979
Valued Contributor III

Re: Dynamic time expression-selection

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
Esteemed Contributor

Re: Dynamic time expression-selection

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

try to describe the usecase.

omarbensalem
Esteemed Contributor

Re: Dynamic time expression-selection

maybe sthing like;

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

beck110979
Valued Contributor III

Re: Dynamic time expression-selection

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

beck110979
Valued Contributor III

Re: Dynamic time expression-selection

Hi Omar,

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

beck110979
Valued Contributor III

Re: Dynamic time expression-selection

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
Valued Contributor III

Re: Dynamic time expression-selection

Hey Beck,

Is this what you want to?

Capturar.PNG

Cheers

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
beck110979
Valued Contributor III

Re: Dynamic time expression-selection

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?