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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Counting records of a chart

Hi everyone, does anybody now how to count the records that a Simple Table has currently. Is there any way using VBSCRIPT to count them?

Thanks.

1 Solution

Accepted Solutions
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Yes, there is an API for that. Here is an example from the API Guide:

set chart = ActiveDocument.Sheets("Main").CreateStraightTable
chart.AddDimension "Class"
chart.AddDimension "Member"
chart.AddExpression "only(MemberComment)"
msgbox("number of class members = "&chart. GetNoOfRows)

Ask me about Qlik Sense Expert Class!

View solution in original post

2 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Yes, there is an API for that. Here is an example from the API Guide:

set chart = ActiveDocument.Sheets("Main").CreateStraightTable
chart.AddDimension "Class"
chart.AddDimension "Member"
chart.AddExpression "only(MemberComment)"
msgbox("number of class members = "&chart. GetNoOfRows)

Ask me about Qlik Sense Expert Class!
Not applicable
Author

Thanks a lot!