Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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