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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Larsstoel
Contributor II
Contributor II

Change date by set analyse

Good afternoon,

I am trying to write a formula that picks a different date for part of my formula. Unfortunately, this is not quite successful yet.

The date field I am using is uiterste_besteldatum. I filter in the app by filters based on year(uiterste_besteldatum) and week(uiterste_besteldatum). This gives me 7 dates to each other in the columns of my multi KPI (dimention).

Now I want to add values for some of the departments under the date selected and some of the departments should have the dates from the day after come under that date. I have written the formula the way below, it just does not work yet. Is there anyone who can help me? Thanks in advance!

 

sum({<afdeling = {'late dienst'}>} Geplande_uren)
+
Sum({<[Uiterste_besteldatum] = {"=date([Uiterste_besteldatum]+1)"}, afdeling = {'vroege dienst'}>} Geplande_uren)

 

Labels (1)
2 Replies
Vegar
MVP
MVP

Could it be this you are trying to do?

sum({<afdeling = {'late dienst'}>} Geplande_uren)
+
Sum({<[Uiterste_besteldatum] = {"='$(=date([Uiterste_besteldatum]+1))'"}, afdeling = {'vroege dienst'}>} Geplande_uren)

 

Larsstoel
Contributor II
Contributor II
Author

Hi Vegar,

Thank you for your answer.
When i try to use your suggestion i seems like te formula only does the part before the + Do you have another suggestion? 

Thank you!