Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Concat getFieldSelection

Hi i have this problem, i need to concat a getfieldselection in this set analisys, someone can help me? in this way it show me all month, and not all i selected only:

=if(GetSelectedCount(MESEIN,'','$')>0, '('&Concat(Distinct MESEIN,'|')&')', '('&Concat(Distinct MESEOUT,'|')&')' )

1 Solution

Accepted Solutions
Highlighted

Re: Concat getFieldSelection

May be try this

=if(GetSelectedCount(MESEIN,'','$')>0, '('&Concat({$} Distinct MESEIN,'|')&')', '('&Concat({$} Distinct MESEOUT,'|')&')' )

View solution in original post

15 Replies
Highlighted

Re: Concat getFieldSelection

Is this expression in inherited state or alternate state object?

Highlighted

Re: Concat getFieldSelection

May be try this

=if(GetSelectedCount(MESEIN,'','$')>0, '('&Concat({$} Distinct MESEIN,'|')&')', '('&Concat({$} Distinct MESEOUT,'|')&')' )

View solution in original post

Highlighted
Creator III
Creator III

Re: Concat getFieldSelection

wow great...but  i not understand... why with that {$} it work... what it mean?

Highlighted

Re: Concat getFieldSelection

My guess is that the object was in alternate state whereas you were making selection in MESEIN in inherited state... to tell the expression to look in inherited state, we used $

Highlighted
Creator III
Creator III

Re: Concat getFieldSelection

so i want to select GetFieldSelection(<name_field,'','$')

Highlighted

Re: Concat getFieldSelection

Not sure what you mean?

Highlighted
Creator III
Creator III

Re: Concat getFieldSelection

i mean the same did you do with {$}, i want to do the same using the expression in Concat:

GetFieldSelection(MESEIN,'','$'), becouse i see if i use this expression in a text area i see the right value of MESEIN in the default state.

Your expression is correct i didn't know if i put into Concat {$} i can do the same of GetFieldSelection(MESEIN,'','$').

becouse is i use the GetFieldSelection into Concat it is wrong, but if i use the {$} all is correct.

thanks

Highlighted

Re: Concat getFieldSelection

GetFieldSelection is a different kind of function compared to Sum, Concat, Avg, Min, Max.... and specify state in it... you use the third parameter... which you already did

GetFieldSelection(MESEIN,'','$')

Highlighted
Creator III
Creator III

Re: Concat getFieldSelection

sure, but if i put  GetFieldSelection(MESEIN,'','$') into Concat in this way it not work:


=if(GetSelectedCount(MESEIN,'','$')>0, '('&Concat( Distinct GetFieldSelection(MESEIN,'','$'),'|')&')', '('&Concat( Distinct GetFieldSelection(MESEOUT,'','$'),'|')&')' )


but if i use like you did, it work:


=if(GetSelectedCount(MESEIN,'','$')>0, '('&Concat({$} Distinct MESEIN,'|')&')', '('&Concat({$} Distinct MESEOUT,'|')&')' )