topic Re: What does 'Get SelectedCount' actually do ? in QlikView

What does 'Get SelectedCount' actually do ?

Tue, 27 May 2014 10:01:52 GMT

Hi,

I've come across a function (??) called GetSelectCount in a script. What does it actually do ? The actual code is as follows:

=If(GetSelectCount($(SalesYear))=0,Year(Today()),MaxString($(SalesYear)))

What does it count ?

Thanks for your help

Re: What does 'Get SelectedCount' actually do ?

PradeepReddy — Tue, 27 May 2014 10:09:25 GMT

Hi,

Getselectedcount() - Function returns the number values we are selecting in that Field.

In Your case,

If you are not selecting any year, it returns the Current Year,

If you are selecting one or more than one year, it returns maximum of the slected year.

Thanks,

Pradeep

Re: What does 'Get SelectedCount' actually do ?

Tue, 27 May 2014 10:09:38 GMT

GetSelectedCount(fieldname [, includeexcluded=false])

returns the number of selected values in the field named fieldname. If includeexcluded is stated as true, the count will include selected values which are excluded by selections in another field.

Examples:

getselectedcount( Customers )
getselectedcount( Customers, true )

Re: What does 'Get SelectedCount' actually do ?

tresB — Tue, 27 May 2014 10:12:30 GMT

Here SalesYear is a variable and gets expanded with dollar sign. It is expected to return a field name. Hence the getselectedcount($(SalesYear)) would return number of field values that are selected in that field.

Re: What does 'Get SelectedCount' actually do ?

Tue, 27 May 2014 10:38:09 GMT

OK...so are you saying if I select years 2010 and 2012 then the number of field values returned will be 2 ?

Re: What does 'Get SelectedCount' actually do ?

israrkhan — Tue, 27 May 2014 10:48:44 GMT

No,

if you will select 2010 and 2011, it will return you 2011, and if you will select 2011, 2012, 2013 it will return you 2013,

simply it will return you the maximum selected year, if nothing is selected than it will return you the maximum year from that listbox.

Re: What does 'Get SelectedCount' actually do ?

tresB — Tue, 27 May 2014 10:51:55 GMT

Goto variable overview window and see the definition of the variable. Then you would understand for which field the result is expected.

Re: What does 'Get SelectedCount' actually do ?

Tue, 27 May 2014 11:21:10 GMT

Ah thank you...it's the value of the field, not the 'number of field values' as tresesco suggested.

I understand it now.

Re: What does 'Get SelectedCount' actually do ?

tresB — Tue, 27 May 2014 11:23:35 GMT

Dear,

what I said was about getselectedcount() alone (that is exactly what you asked for in your question title) and not about the entire expression. However, it's a misunderstanding, good that you got your answer.

Re: What does 'Get SelectedCount' actually do ?

israrkhan — Tue, 27 May 2014 11:27:11 GMT

if you have got the answer ,than close the thread..

Re: What does 'Get SelectedCount' actually do ?

Tue, 27 May 2014 11:27:50 GMT

Why do you think SalesYear is a variable ? It's a field name.

You've completely confused me again !

Can someone tell me.....does GetSelectedCount return a count or a value ?

Re: What does 'Get SelectedCount' actually do ?

Tue, 27 May 2014 11:35:07 GMT

Well, I haven't got the answer.

You are saying GetSelectedCount returns a value, whereas Tresesco is saying GetSelectedCount returns the number of field values selected. These are two different things and I'm still none the wiser.

Help !

Re: What does 'Get SelectedCount' actually do ?

israrkhan — Tue, 27 May 2014 11:46:01 GMT

Yes, Tresesco said right...

GetSelectedCount Return the "Number of Selected values" .

let say, if you are writing this expression in text object =GetSelectedCount(Year), and you have selected year 2011 and 2012, in this case ,it will return you "number of selected values in year field" and you will see "2" in the text box.

but what i tried to explain you ,that is use of GetSelectedCount in your expression, which is

=If(GetSelectCount($(SalesYear))=0,Year(Today()),MaxString($(SalesYear))),

here in the expression , GetSelectedCount will return result to your IF statement, and than if statement will return the final result that will be displayed in your object, that result will be Maximum Year.

so you need to understand if statement as well..

hope it help...

Re: Re: What does 'Get SelectedCount' actually do ?

tresB — Tue, 27 May 2014 11:46:09 GMT

See the attached qvw to come out of confusion.

Re: What does 'Get SelectedCount' actually do ?

Tue, 27 May 2014 12:48:18 GMT

Right. I think there was a misunderstanding of language here. I became confused when you said, "No" !

Thank you to Tresesco for the correct solution to the original enquiry.

And thank you for explaining the meaning of the full script statement which includes the MaxString function.