Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
kmmqlick
Contributor III
Contributor III

Finding First Launch date Based on Selection

Thanks all for support in advance,

I have one issue with finding Launch date of Product based on selections.

I Group,Product,FirstLaunch and country as fields

GroupProductCountryFLDate
G1P1IndiaJan-2015
G1P1CanadaMar-2019
G1P1JapanNov-2017
G1P1ChainaDec-2016
G1P1PakistanMar-2018
G1P2IndiaMay-2016
G1P2CanadaJul-2017
G1P2JapanFeb-2018
G1P2ChainaDec-2019
G1P2PakistanJan-2015
G2P3IndiaJan-2017
G2P3ChinaMar-2017
G2P3USADec-2018

 

I have Group ,Product and country filter i want to show a FirstLaunchDate based on selections in a KPI.

Country filter is multiselecting filter , when multiple countries are selected i want to show min of FLDate

Thanks all once Again

Labels (1)
3 Replies
MayilVahanan

HI @kmmqlick 

Try like below

Min(FLDate)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Vegar
MVP
MVP

If @MayilVahanan does not work then try this.

=Date(Min(date#(FLDate, 'MMM-YYY')) , 'MMM-YYYY') 

kmmqlick
Contributor III
Contributor III
Author

Thank you  @MayilVahanan  and @Vegar  for your response.

I am not getting in month-year format for your expressions. 

i used Date(MinString(FLDate),'MMM-YYYY') it is working fine