Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
vchuprina
Specialist
Specialist

Min Week Ending date in current selection

Could someone help with Set Analysis. For example I have [Week_Ending_Date] field and selected following weeks:

7/2/2016

7/9/2016

6/25/2016

How can I chose only min Week_Ending_Date from current selection - 6/25/2016?

Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").
1 Reply
Anonymous
Not applicable

Hi

Please try this ...

I am thinking you have missed the aggr field to calculate Yourfield

Sum({$< [Week_Ending_Date]={"$(=Date((Min( [Week_Ending_Date])), 'MM/DD/YYYY'))"}>} Yourfield)


other wise


we have to use    P or E for set analysis