topic Re: Can anyone give me an example of getselectedCount() function in QlikView

Can anyone give me an example of getselectedCount() function

ananyaghosh — Thu, 26 Mar 2015 08:40:32 GMT

What is the use of getselectedcount() function? can anyone give me an example?

Re: Can anyone give me an example of getselectedCount() function

robert_mika — Thu, 26 Mar 2015 08:46:44 GMT

From Help:

getnotselectedcount ( FieldName [, IncludeExcluded])

Returns the current number of not-selected values in a field in a field with AND-Mode in List Boxes (red values in list box).

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

getnotselectedcount ( Year )

getnotselectedcount (Year,true())

Re: Can anyone give me an example of getselectedCount() function

Peter_Cammaert — Thu, 26 Mar 2015 08:50:40 GMT

In order to hide an object when more than one dimension value is selected, add this to the Conditional Show expression box:

getselectedcount(CustomerName) = 1

Can be used for displaying a phone number to call in a large font in a text box, whenever you select a single customer in a list box or in a table.

BTW use getpossiblecount() if you want to show information whenever a single field value is indirectly selected (through association)

Re: Can anyone give me an example of getselectedCount() function

anbu1984 — Thu, 26 Mar 2015 08:56:02 GMT

Check this

Re: Can anyone give me an example of getselectedCount() function

ananyaghosh — Thu, 26 Mar 2015 09:20:15 GMT

As I am using QlikView personal edition.Please give me the code for it.

Re: Can anyone give me an example of getselectedCount() function

ananyaghosh — Thu, 26 Mar 2015 09:27:42 GMT

You mean you have to use getselectedcount at front end rather than use in script?

can give me an screen shot of how to use it?

Re: Can anyone give me an example of getselectedCount() function

anbu1984 — Thu, 26 Mar 2015 09:32:06 GMT

Load * Inline [

billing,payment

tenders,100

dues section,200

aaa,50

bbb,60 ];

Text box expr

='Selected count: '&GetSelectedCount(billing)

Re: Can anyone give me an example of getselectedCount() function

sudeepkm — Thu, 26 Mar 2015 09:40:38 GMT

one scenario could be like below.

Assume that you have a field Region and you want to display the data in a table box when end user selects at least one Region. then you can use the getselectedcount(Region) condition to display the data in the table box like below.

Go to the Table box properties and add condition as getSelectedCount(Region)>0 that means whenever at least one value in the field Region is selected then the chart/table will display data.

now if you select one or more value in the Region field then the data becomes visible in the table.