Discussion board where members can get started with QlikView.
I have a field called 'MonthName' with values Jan-Dec.
If multiple values are selected say Jan,Feb,Mar how to find the maximum of the month selected.
I tried giving Max(GetFieldSelections(MonthName)) but i dint ge the Max month selected. It was showing '-'.
Can anyone help me with a correct expression please?
It seems your monthname is text value not in the date format..
so you can simply load inline data for Monthname and value and link that with you model and then do max of value or else calculate your monthname from a date function.
Date(datefield,'MMM') as monthName
load * inline