topic Re: Concat getFieldSelection in QlikView

Concat getFieldSelection

danosoft — Wed, 25 Nov 2020 16:16:04 GMT

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,'|')&')' )

Re: Concat getFieldSelection

sunny_talwar — Wed, 18 Jul 2018 15:16:07 GMT

Is this expression in inherited state or alternate state object?

Re: Concat getFieldSelection

sunny_talwar — Wed, 18 Jul 2018 15:16:38 GMT

May be try this

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

Re: Concat getFieldSelection

danosoft — Wed, 18 Jul 2018 15:38:02 GMT

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

Re: Concat getFieldSelection

sunny_talwar — Wed, 18 Jul 2018 15:43:41 GMT

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 $

Re: Concat getFieldSelection

danosoft — Wed, 18 Jul 2018 15:53:40 GMT

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

Re: Concat getFieldSelection

sunny_talwar — Wed, 18 Jul 2018 16:01:15 GMT

Not sure what you mean?

Re: Concat getFieldSelection

danosoft — Thu, 19 Jul 2018 06:47:34 GMT

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

Re: Concat getFieldSelection

sunny_talwar — Thu, 19 Jul 2018 11:18:41 GMT

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,'','$')

Re: Concat getFieldSelection

danosoft — Thu, 19 Jul 2018 11:49:59 GMT

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,'|')&')' )

Re: Concat getFieldSelection

sunny_talwar — Thu, 19 Jul 2018 11:52:12 GMT

But why do you want to add GetFieldSelections within Concat? I think I am not sure why you want to do that? What exactly are you trying to do?

Re: Concat getFieldSelection

danosoft — Thu, 19 Jul 2018 13:16:53 GMT

Sunny with your expression is right all ok... only i ask why you use there in that position the '$', and you replied me.

i want to use GetFieldSelection, becouse i want to select the MESEIN i had choose in my listbox

Re: Concat getFieldSelection

sunny_talwar — Thu, 19 Jul 2018 13:21:22 GMT

Are you saying that you want to use GetFieldSelection instead of Concat?

Re: Concat getFieldSelection

danosoft — Thu, 19 Jul 2018 13:25:11 GMT

no GetFieldSelection(MESEIN,'','$') need to be the selection of my MESEIN i choose in my listbox in my default state.

But i see it can be right NOT using GetFieldSelection(MESEIN,'','$') but using only '{$}' before Distinct MESEIN

Re: Concat getFieldSelection

sunny_talwar — Thu, 19 Jul 2018 13:27:13 GMT

Not sure I understand... but once you have made a selection in MESEIN.... the below should be true....

GetFieldSelection(MESEIN,'','$') = Concat({$} Distinct MESEIN,'')

Re: Concat getFieldSelection

danosoft — Thu, 19 Jul 2018 13:30:11 GMT

yes, this is right