topic Re: InputBox in QlikView

InputBox

emteam162 — Tue, 28 May 2013 21:45:35 GMT

Hi,

I have issue with input box

i use this macro to remove variable from input box

with GetRowCount=6

when i remove two variables normally i will have GetRowCount=4 when i save my application

but GetRowCount is still have value 6

set obj = ActiveDocument.GetSheetObject("IB16")

for RowIter = 0 to obj.GetRowCount-1

msgbox obj.GetRowCount & " RowIter " & RowIter

'for ColIter =0 to obj.GetColumnCount-1

set cell = obj.GetCell(RowIter,2)

msgbox(cell.Text)

if len(cell.Text)=0 then

obj.RemoveVariable RowIter

end if

i want remove all variable how has null value from input box

Many thanks for your help

Emteam

Re: InputBox

Wed, 29 May 2013 02:47:38 GMT

see this link,for clear value in input box.

http://community.qlik.com/thread/64442

http://community.qlik.com/thread/72231

try this code

sub clear

set v = ActiveDocument.Variables("Variable1")

prop = v.GetProperties

dim list

list=Array("abc","45","xyz","")

prop.PreDefinedList = list

v.SetProperties prop

set ClearAllib = ActiveDocument.GetSheetObject("IB10")

ClearAllib.SetVariableContent 0,"",true

Erase list

list=Array("abc","45","xyz")

prop.PreDefinedList = list

v.SetProperties prop

end sub

Regards

vishwaranjan

Re: InputBox

emteam162 — Wed, 29 May 2013 22:47:45 GMT

Hi,

Many thanks for your answer its help me

Best Regards,

Emteam

Re: InputBox

Thu, 20 Jun 2013 07:03:15 GMT

hi emteam162

if your problem resolved then marked it as either correct or helpful according to your question, and close this thread, so that it might be helpful for other developer.

Regards