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: 
pandreozzi
Creator
Creator

Query for a Date

Hi all. I would like to create a case statement that searches a table but only pulls date based on the date in the table plus 11 days. xan

Example.

case where (mytabledate >= mytabledate +11)

This needs to search the entire table records base so on the fist match not to exit the script it needs to continue moving through the field until the script reaches the end.


Not sure is this is a good option or using an expression in my chart would be better.

1 Reply
Anil_Babu_Samineni

This one is good option, Even though we can write set expression for the same condition..

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