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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Possible Value Row Count of List Box with Macro?

Dear all,

I would like to count the rows of a list box, but only for possible values.

The list box (ID: "LB15"; Name:"Änderungsbelegnr") holds 176 values in total, but only 145 are possible to select.

With the below Macro I get the overall count of 176.

Any ideas how to build in the condition to only count possible values?

Sub Grundgesamtheit
set table = ActiveDocument.GetSheetObject("LB15")
rows = table.GetRowCount
ActiveDocument.Variables("vNoRowsLB15").SetContent rows, True
Msgbox ("Grundgesamtheit: " & rows & " Änderungsbelegnummern")
End Sub

Any help appreciated!

Regards,

Daniela

0 Replies