Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
adiarnon
Creator III
Creator III

SYSTEM FUNCTION

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

is it possible?

Labels (1)
1 Solution

Accepted Solutions
tresB
Champion III
Champion III

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

View solution in original post

4 Replies
trdandamudi
Master II
Master II

Are you looking for this:

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

tresB
Champion III
Champion III

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

Anonymous
Not applicable

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

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

kaushiknsolanki
MVP
MVP

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!