Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

vchuprina
New Contributor II

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?

1 Reply
galax_allu
Valued Contributor

Re: Min Week Ending date in current selection

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

Community Browser