topic Re: getfieldselections & getselectedcount return different fieldcount -> IncludeExcluded in QlikView

getfieldselections & getselectedcount return different fieldcount -> IncludeExcluded

ni_avoss — Mon, 23 Jan 2017 16:41:43 GMT

hi there,

in the frontend I want to combine the functions getfieldselections & getselectedcount to dynamically show fieldselections, based on the number of selections.

the problem: both return different fieldcount.

I found out that getselectedcount has the parameter IncludeExcluded, which defaults to false. If set to true() both functions return the same fieldcount so I guess getfieldselections includes excluded values which is quite confusing.

Is there any way to not include exluded values in getfieldselections() ? Or any different ideas for a workaround?

thanks,

alex

Re: getfieldselections & getselectedcount return different fieldcount -> IncludeExcluded

sunny_talwar — Mon, 23 Jan 2017 16:45:33 GMT

May be use Concat() instead of GetFieldSelections?

If(GetSelectedCount() > 0, Concat(DISTINCT FieldName))

Re: getfieldselections & getselectedcount return different fieldcount -> IncludeExcluded

ni_avoss — Mon, 23 Jan 2017 17:03:25 GMT

well, yeah that might be an idea. the useful parameter in that function was that it automatically switches from concatenation to a summary ("x of y") after hitting MaxValues. But I guess I can rebuild this more or less if there is no other way

thanks

Re: getfieldselections & getselectedcount return different fieldcount -> IncludeExcluded

ni_avoss — Mon, 23 Jan 2017 17:07:17 GMT

oh just tried this. concat() also return exluded values, thus will not work

Re: getfieldselections & getselectedcount return different fieldcount -> IncludeExcluded

sunny_talwar — Mon, 23 Jan 2017 17:09:09 GMT

Concat() includes excluded values, can you share a sample of what you trying to get?

Re: getfieldselections & getselectedcount return different fieldcount -> IncludeExcluded

Anonymous — Mon, 23 Jan 2017 17:10:51 GMT

=if(Aggr(Sum(1), FIELDNAME)>0,

'Selected: $(=Concat(DISTINCT FIELDNAME, ', '))',

'Others: $(=Concat({<FIELDNAM=E({$})>} DISTINCT FIELDNAME, ', '))')

Re: getfieldselections & getselectedcount return different fieldcount -> IncludeExcluded

ni_avoss — Mon, 23 Jan 2017 17:16:42 GMT

let me try to explain:

I got two boxes. One which is a standard listbox, second is a summary of the selection (works similar to text field). Basically I try that both boxes show the same.

The problem: when extending my selection (to other fields), the selection within the listbox shrinks accordingly to what is really shown. Not so in the summary box which uses now the following expression (GetFieldSelections just got replaced with concat):

=if(GetSelectedCount(Channel)=0,'Channel',

if(GetSelectedCount(Channel)>5,GetSelectedCount(Channel)&' Channels',

Concat(Channel,', ')))

is that clear ?

Re: getfieldselections & getselectedcount return different fieldcount -> IncludeExcluded

sunny_talwar — Mon, 23 Jan 2017 17:36:06 GMT

So you are saying that Concat() is showing Channels which are not selected?

Re: getfieldselections & getselectedcount return different fieldcount -> IncludeExcluded

ni_avoss — Mon, 23 Jan 2017 17:39:41 GMT

they have been selected before but further selection excludes values from the initial selection

Re: getfieldselections & getselectedcount return different fieldcount -> IncludeExcluded

marcus_sommer — Mon, 23 Jan 2017 19:18:58 GMT

I think the best would be if you provide a small example.

- Marcus

Re: getfieldselections & getselectedcount return different fieldcount -> IncludeExcluded

sunny_talwar — Tue, 24 Jan 2017 00:28:03 GMT

I agree with Marcus, I don't really understand what you have and what kind of issue you are running into?

Re: getfieldselections & getselectedcount return different fieldcount -> IncludeExcluded

ni_avoss — Tue, 24 Jan 2017 09:57:41 GMT

Hi Marcus,

while trying to build an example I found out that the approach with concat works fine,

I cannot recall what was wrong there yesterday.

Thank you all for your help, esp. Sunny.

Best,

Alex

Re: getfieldselections & getselectedcount return different fieldcount -> IncludeExcluded

shannoypaul — Thu, 08 Aug 2019 12:58:27 GMT

@sunny_talwar

I tried passing a placeholder in a similar expression, however the Concat() function is not identifying the placeholder:

Expression Used - ='$(vSelectionQuery(Dim1))'

Variable Definintion vSelectionQuery

=If(GetSelectedCount($1)=0,Null(),'&select=' &'$1,' & Concat(Distinct$1,','))

The Place holder $1 in green font works fine, the one in red font in Concat() function doesn't gets assigned with the placeholder.

TIA,

Shannoy

Re: getfieldselections & getselectedcount return different fieldcount -> IncludeExcluded

tellmalaika17 — Tue, 19 May 2020 02:00:49 GMT

Hi,

I have a similar request in Pivot Table. For eg:

Fieldname - Category 1, another field name is country (listed as a,b,c in thsi case)

	Month 1	Month 2
Category 1 Total	20	35
a	10	20
b	5	10
d	5	5

On selection of Country b, i want to exclude the total of b from Category 1 Total. so which means row for country b will be there just the selected country value ie 5 for Month 1 should be removed from Category1 Total.