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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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