Hello,
I need to transform a date in this format:
Semester Year for example: Jan-Jun 2018, Jul-Dec 2018
And to do that in my script I use:
if( match(Num(Month(start_date)),'1','2','3','4','5','6') ,'Jan-Jun','Jul-Dec') &' '& year(start_date) as Semester,
For example my start_date =2015-05-04
Until now, I have the result that I want,
Now I want to display “Semester” on a filter and only one value can be selected at a time in this drop-down list so to do this I use a Qlik sense extension that called (SimpleFiledSelect), Until now I don’t have a problem but ,I need now to display by default, the last semester available selected.
In this extension I have this possibility but I need to found how to display Max( Semester) , because in the reality Qlik cannot display the max of semester because is not a date …
Someone can help me ?? I need to know how to display the maximum of a value like Jul-Dec 2018
