Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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?