topic Re: getselected count function in QlikView

getselected count function

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

can anyone explain getselectedcount function?????? why we use and how?????

Re: getselected count function

Anonymous — Thu, 17 Nov 2016 10:17:14 GMT

From Qv help file:

Chart Field Functions:

getselectedcount (FieldName [, IncludeExcluded])

Returns the current number of selected values in a field.

If IncludeExcluded is true the count will include selected values, which are currently excluded by selections in other fields. If false or omitted these values will not be included.

Examples

getselectedcount ( Year )

getselectedcount ( Year, true( ) )

I.e if you select 2016 & 2015 from field year

getSelectedCount(year) = 2

Re: getselected count function

kaushiknsolanki — Thu, 17 Nov 2016 10:18:45 GMT

Hi,

The function takes the field name as parameter and it will count the numbers of values which are selected in that field.

So example you have country field with 15 values.

If you select 3 values.

The function =GetselectedCount('Country') will return 3 as value.

Regards,

Kaushik Solanki

Re: getselected count function

Chanty4u — Thu, 17 Nov 2016 10:19:31 GMT

Hi,

All get functions here :https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/FieldFunctions/getselectedcount.htm

Re: getselected count function

chhavi376 — Thu, 17 Nov 2016 10:23:12 GMT

Getselectedcount is used to find out that how many values are selected for a particular field.

You can use it to make a particular object conditional when atleast one value is selected in the field

getselectedcount(Fieldname)<>0 can be used in that case

I have attached a sample, if you select an ID, the sum correponding to that ID will be displayed.

But if no ID is selected, the sum disappears

The text box here is conditional.

You can go to the conditions of the text box and see exactly what is happening,

Re: getselected count function

Anonymous — Thu, 17 Nov 2016 10:27:11 GMT

Thanks to all.

Re: getselected count function

girirajsinh — Sat, 07 Jan 2017 18:24:54 GMT

Here in attached document I have tried to clear the understanding over the QlikView Field functions

Please find the attachment and let me know how did you like it.

Re: getselected count function

Anonymous — Wed, 11 Jan 2017 06:21:20 GMT

hai,chhavi

in here where u gave getselected count.i can't undrstnd.

Re: getselected count function

chhavi376 — Wed, 11 Jan 2017 09:48:15 GMT

Hi Sindhu ja,

GetSelectedCount is used in the 'Layout' of the text box, to restrict the visibility of that text box.

It appears only when atleast one value from the multi box is selected(GetSelectedCount(ID)>1 in this case), and disappears when no value (GetSelectedCount(ID)=0 in this case) is selected in the multibox.

Re: getselected count function

Wed, 11 Jan 2017 10:39:40 GMT

Hi Sindhu,

please close the ticket if you got the answer.