Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
dbfg
Contributor III
Contributor III

Trouble with retrieving a date between two variables

Hi All,

I am having trouble with getting an expression to work. Specifically, with the where clause:

{<Rev_Date = {">=$(vWeek7)<=date(vWeek7+6, 'DD/MM/YYYY'))"}>}

The first part: >=$(vWeek7) works correctly, as you can see from the screenshot below:

clipboard_image_0.png

However, as you can see above, the second part: <=date(vWeek7+6, 'DD/MM/YYYY') is not working. I used this individual bit in another expression it works, where I only want to know data for week 7 + 6 days. However, when being used in this between expression, it is being ignored.

Can anybody offer insight into this?

Thanks

Labels (2)
1 Reply
Rohan
Creator
Creator

Hello,

You are just slightly mistaken there. Following is the way that will correctly implement the Date range in the Set Expression :

Aggr_Function({<date={">=$(=Date($(varMinDate))) <=($(=Date($(varMinDate)+6)))"}>} Fields) 

 

 

Set_expression.jpg

 

Let me know if you have  any queries about this.

Thanks & Regards.

Rohan S. Desai