Skip to main content
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!