Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Subba143
Contributor
Contributor

start date and end date range

how to display two dates range

Hi guys,

i am new to qlik sense

i have one requirment.

i have 2 fields
start date and end date in this i have 6 months data

i want to display only latest 4 weeks dates and want to dispaly range of 2 fields

if select start date value 2022.12.01 and end date value 2022.12.10

output:

i want see this range selections 2022.12.01 to 2022.12.10


how to implement this logic in start date and end date filter panel selections

 

Thanks in advance.

 

Regards,

Subba

Labels (5)
1 Reply
DiegoF
Creator
Creator

Hello,

So, I only have one filter called FECHA (Date), and I use this formula if I want to get a range of dates:

If I put it into the filter and Enter, it will get me the values I defined:

FECHA= {">=1/9/2022 <1/12/2022"} 

DiegoF_0-1671616309486.png

In your case, you have 2 filters, start date and end date, where you could just write in each filter 2022.12.01 and  2022.12.10. But if you want to have something like this above, I´m guessing it should be something like:

Datefieldname= {">=2022.12.01 < 2022.12.10"}

I don´t know if you mean this, if not, maybe pass some more info and will try to help.

Diego