Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
NicholeBolivar1
Employee
Employee

Set Analysis with date

Hello everyone, please I need help to create a set analysis so that the date remains from 07/01/2006 to 06/30/2009 and that only the dates between those ranges appear to me.

 

Thanks!!!

2 Replies
Anil_Babu_Samineni

This is for just show the period of needed

Sum({<DateField = {">=07/01/2006<=06/30/2009"}>} Sales)

Below is one for exclude the period

Sum({<DateField -= {">=07/01/2006<=06/30/2009"}>} Sales)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
NicholeBolivar1
Employee
Employee
Author

Thanks!!!