Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
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

   rangstring=100  

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

   f.select rangstring

end sub

-----------------------------------------------------------------------------------

0 Replies