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: 
Not applicable

Filtered List Box

Hi,

I have a requirement were I need to show the last 6 dates in a list box. I have tried to display the same using a formula as below  theList Box.jpg

The expression is as below:

Expression.jpg

but this does not appear to be producing the expected results. I am just getting an empty list box.

Please suggest.

10 Replies
Not applicable
Author

may be can you try like this

=If(Match([Run Date], $(=Max({1} [Run Date])), $(=Max({1} [Run Date]))-1,$(=Max({1} [Run Date]))-2),[Run Date])