topic Value present in a list box or not using Macro in QlikView

Value present in a list box or not using Macro

Fri, 15 Mar 2013 09:41:13 GMT

Hi guys

Is it possible to write a macro which checks whether a particular value is present in a list box or not.

For example if i have a list box of country, i want to check whether Australia is present in listbox or not.

Re: Value present in a list box or not using Macro

jonathandienst — Fri, 15 Mar 2013 09:47:58 GMT

Depending on what you need to do with the result, you can do that within an expression (incl condition display/calculations) and dimensions without resorting to a macro.

Being present in the list box means that it exists in the field. Or do you mean selected in the list box?

Regards

Jonathan

Re: Value present in a list box or not using Macro

kaushiknsolanki — Fri, 15 Mar 2013 09:55:26 GMT

Hi,

Find below the macro for the same,

Sub Check

vCheck = 0
set v = ActiveDocument.Variables("vYear")
vYear = v.GetContent.String

set table = ActiveDocument.GetSheetObject( "LB01" )
for RowIter = 0 to table.GetRowCount-1
    for ColIter =0 to table.GetColumnCount-1
        set cell = table.GetCell(RowIter,ColIter)
         if vYear = cell.Text then
           vCheck = 1
         end if
    next
next

if vCheck = 1 then
msgbox "Value Matched"
Else
Msgbox "Value Not Matched"
End if

End Sub

Here variable vYear is created to take input from user and checking the same value in field.

Regards,

Kaushik Solanki

Re: Value present in a list box or not using Macro

sushil353 — Fri, 15 Mar 2013 10:10:15 GMT

Try this macro:

sub findlistvalue

set table = ActiveDocument.GetSheetObject( "LB08" )

for RowIter = 0 to table.GetRowCount-1

for ColIter =0 to table.GetColumnCount-1

set cell = table.GetCell(RowIter,ColIter)

if(cell.Text="India") Then msgbox(cell.Text)

end sub

Note:

Change the "LB08" according to your list value.

HTH

Sushil