Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
manojkumargowda
Creator
Creator

Concat with GetFieldSelections in QlikSense

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))

,',')

0 Replies