Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
vchuprina
Specialist
Specialist
‎2016-07-29 11:18 AM

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").
174 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2016-07-29 11:29 AM

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

123 Views