Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
jonasbombay
Contributor II
Contributor II

How to insert date filter variable into set expression?

Hello,

Qlik sense beginner here. I have a date filter expression which I'm gonna re-use several times throughout my app, and therefore I have created a variable with it:

dateRange: '">=$(=Date(MakeDate(year(Today()),01,01)))<=$(=Date(today())))"'

I've tested using this variable in set expressions like the one but haven't got it to work. 

Sum({<Date= {$(dateRange)}>} FacebookReach) + Sum({<Date= {$(dateRange)}>} YoutubeReach)

Any ideas?

 

 

 

1 Solution

Accepted Solutions
nazaQ
Partner - Contributor III
Partner - Contributor III

Hi,
here my example:
dateRange: >=$(=date(40789))<=$(=date(40795))

Count({<OrderDate={"$(dateRange)"}>} OrderID)

Let me know if it solves your problems.
Thank you

View solution in original post

2 Replies
nazaQ
Partner - Contributor III
Partner - Contributor III

Hi,
here my example:
dateRange: >=$(=date(40789))<=$(=date(40795))

Count({<OrderDate={"$(dateRange)"}>} OrderID)

Let me know if it solves your problems.
Thank you
jonasbombay
Contributor II
Contributor II
Author

Thanks! Works like a charm!