Solved: SYSTEM FUNCTION - Qlik Community

adiarnon · ‎2016-09-13

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

is it possible?

tresesco · ‎2016-09-13

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

trdandamudi · ‎2016-09-13

Are you looking for this:

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

tresesco · ‎2016-09-13

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

Anonymous · ‎2016-09-13

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

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

kaushiknsolanki · ‎2016-09-13

Hi,

You can use this macro.

Sub Test

set cs = ActiveDocument.GetSheetObject("CS01")

msgbox(cs.GetNoOfRows)

End Sub

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

SYSTEM FUNCTION