Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How could the records not show if no values match?

Hi all,

Today i met a requirement and do the range selection via macro, i wanna to let the table box which contain the field 'Tbl_BDN_Reason.Id' show nothing if no values match a bit like the sql query script where clause script.  How could the function implement? Currently the vbscript below could do no selection for the field but show all values. (there is no '100' value in field 'Tbl_BDN_Reason.Id')       Appreciate ur help !


sub selectField


   set f=activedocument.fields("Tbl_BDN_Reason.Id")

   f.select rangstring

end sub


0 Replies