topic reuse variable between two reports in QlikView

reuse variable between two reports

Anonymous — Wed, 07 Aug 2013 14:34:52 GMT

Hi all,

i've got tow QV report with a commun variable v_KPI.

the report 1 got a button with two actions : the first action affect to v_KPI the value 1, and the second action "Open Qlikview Document"

i'm looking for a tip to transmit the value v_KPI from the report A to B.

an idea ..??

thanks

Re: reuse variable between two reports

Gysbert_Wassenaar — Wed, 07 Aug 2013 17:23:28 GMT

See this discussion. Or this one.

Re: reuse variable between two reports

Anonymous — Fri, 09 Aug 2013 08:33:13 GMT

Hi Gysbert,

i tested the second one, with the macro :

sub Regs_Doc
set Var=ActiveDocument.Variables("v_KPI")
set App=ActiveDocument.GetApplication
set UserFile = App.OpenDoc ("bm_kpi_regs.qvw","","")
UserFile.CreateVariable "v_KPI"
set v = UserFile.Variables("v_KPI")
v.SetContent Var.GetContent. String,true
ActiveDocument.ClearAll false
end sub

but, when i tried it on my accespoint it doesn't work !! incompatiblity with ajax ??

regard