Concat with GetFieldSelections in QlikSense

[manojkumargowda]

Hi All,

I need to concat startmonth column grouped by Id column. And also I'm using getfieldselection function, to select startmonth only for the selected endmonth.

But, below expression is not concatenating correctly. Issue is with the concat part. Can you please tell me, whats wrong here.

=Concat(TOTAL <Id>

if(len(GetFieldSelections(Endmonth))=0,startmonth,

If( Match( (Date(monthstart(startmonth), 'MMM-YY')) ,

$(=Chr(39) & GetFieldSelections(Endmonth,Chr(39)&','&Chr(39),12) & Chr(39) ) ),

startmonth))

,',')