topic Re: SYSTEM FUNCTION in QlikView

SYSTEM FUNCTION

adiarnon — Tue, 13 Sep 2016 07:47:54 GMT

I need a function that return me how many fields are selected in the current selection now

is it possible?

trdandamudi — Tue, 13 Sep 2016 07:51:32 GMT

Are you looking for this:

=getcurrentselections ( chr(13)&chr(10) , ' = ' )

tresB — Tue, 13 Sep 2016 07:52:41 GMT

AFAIK there is no such system function. However, you can achieve that using some expression as I suggested here : Count of Current Selections

Anonymous — Tue, 13 Sep 2016 07:54:09 GMT

with this Expression (based on Thirumalas solution) you get the number fo selected fields

=substringcount(getcurrentselections ( chr(13)&chr(10) , ' = ' ) ,'=')

kaushiknsolanki — Tue, 13 Sep 2016 07:59:36 GMT

Hi,

You can use this macro.

Sub Test

set cs = ActiveDocument.GetSheetObject("CS01")

msgbox(cs.GetNoOfRows)

End Sub

Regards,

Kaushik Solanki