Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Using Date-formula to implement in Filterdatebox

Hi all,

Have this Formular and work fine. Output is a date:

FirstWorkDate(Max(DBDate), 3, $(Holidays))

When I use this in a filterbox to filter Data from Datedimension "DBDate" got an invalid dimension. I guess the problem is this: Subtracting 3 days from the common calendar and not from the DBDate-Datedimension. So in the end the filterbox has a unassociated date which is not part of the DBDate-Datedimension. Could that be? If yes, have anybody a workaround?

thanks for any help.

 

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Find a workaround which worked fine. So I bypass the issue to associate the filtering with the dimesions by using a ">" and a If. Solution:

=If(DBDate > FirstWorkDate(Max(DBDate), 3, $(Holidays)))

View solution in original post

2 Replies
Highlighted
Creator II
Creator II

Can you explain what you want in dimension .

Highlighted
Creator III
Creator III

Find a workaround which worked fine. So I bypass the issue to associate the filtering with the dimesions by using a ">" and a If. Solution:

=If(DBDate > FirstWorkDate(Max(DBDate), 3, $(Holidays)))

View solution in original post