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

43 Replies
Thiago_Justen_

Yes, it is possible.

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

I'm preparing something with it.

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

I would be grateful for any ideas or suggestions

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
Thiago_Justen_

Add this expression for the table's title. It's gonna be more dinamical and atractive:

=GetFieldSelections(Projekte) & ' Projects'

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

If you want to talk more about this thread in particular, you can add me on Skype: justen.thiago.

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

Hi Thiago,

thanks a lot for your help and time, i am not able to open the extension, i am now at home und will try to open tomorrow in the office, and will immediately report when i have any results. ok

Thiago_Justen_

That's ok Beck. Here is a snapshot, just to you figure it out what you'll find into the app.

Capturar.PNG

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

Thiago,

thanks a lot for your help and your time, i will definitely inform tomorrow about my results.

Thanks a lot

beck_bakytbek
Master
Master
Author

Hi Thiago,

good morning. Thiago i am not able to open your extension. do you have the zip-file for your extension?