topic Re: Macro conditional show in Excel in QlikView

Macro conditional show in Excel

Thu, 08 May 2014 17:41:18 GMT

Hi all,

I have a variable in QV named "vDimesionShow" and I want to use this variable to determing which object to show. I have tried if-then statements to no avail. Could somebody please help with the syntax!!!

set v = ActiveDocument.Variables("vShowDimension") ....

if v.GetContent = 0 then

aryExport(5,0) = "TX1549"

aryExport(5,1) = "Sheet1"

aryExport(5,2) = "D34"

aryExport(5,3) = "image"

end if

if v.GetContent = 1 then

aryExport(5,0) = "TX1550"

aryExport(5,1) = "Sheet1"

aryExport(5,2) = "D34"

aryExport(5,3) = "image"

end if

Re: Macro conditional show in Excel

Fri, 09 May 2014 09:16:20 GMT

Maybe try adding .string at the end of the GetContent line to explicitly define it?

Re: Macro conditional show in Excel

bbi_mba_76 — Fri, 09 May 2014 09:52:26 GMT

Hi,

you could try this macro:

sub test

set v_macro = ActiveDocument.Variables("vShowDimension")

msgbox v_macro.GetContent.String

end sub

Re: Macro conditional show in Excel

alexandros17 — Fri, 09 May 2014 09:59:44 GMT

Try This

set v = ActiveDocument.GetVariable("showW")

select case v.GetContent.String

case 0

...

case else

end select

Let me know