Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

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

Tags (1)
Community Browser