topic Re: Simple Condition Check in QlikView

Simple Condition Check

alvinford — Tue, 30 Oct 2012 06:36:28 GMT

Hi All,

I want to Check a condtion for the Variable using the Macro . I tried the below, its throwing an error.

if the vDetails Value is 2 then I want to display a msg box

sub Message
set albm =ActiveDocument.Variables("vDetails")
if(albm)=2 then
msgbox "You have items with No. Name"
end if
end sub

Regards,

Alvin.

jonathandienst — Tue, 30 Oct 2012 06:41:21 GMT

You need

if(Albm.GetContent.String) = 2 then

Hope that helps

Jonathan

alvinford — Tue, 30 Oct 2012 06:56:35 GMT

Hi Jonathan,

Thanks for the Reply. Need some more help from you.

The above is working fine. What I need is once the condition is Satisfied I want to set the Variable value as 1.

As the value Albm is 2 Want to set it to 1 using the Macro.

Regards,

Alvin.

alvinford — Tue, 30 Oct 2012 07:37:53 GMT

Hi,

I could able to do it ..

Thanks .

Alvin