topic Re: How to export formula with Set analysis using macro in QlikView

How to export formula with Set analysis using macro

Anonymous — Mon, 25 Sep 2017 08:33:30 GMT

I need to export the value of this formula in an excel . Formula contains set analysis.

When I try to export formula it doesn't recognize the set analysis..can anybody please help?

testresult = activedocument.Evaluate("num(only({<Last8WeeksReferencedateOpened = {"$(=max(Last8WeeksReferencedateOpened))"}>}Aggr($(vAging_Incidents_weekly),Last8WeeksReferencedateOpened)),'#0.00')")

msgbox testresult

Re: How to export formula with Set analysis using macro

Frank_Hartmann — Mon, 25 Sep 2017 08:58:26 GMT

1. create a variable e.g vTest

=num(only({<Last8WeeksReferencedateOpened = {"$(=max(Last8WeeksReferencedateOpened))"}>}Aggr($(vAging_Incidents_weekly),Last8WeeksReferencedateOpened)),'#0.00')

2. Change Macro to:

sub test

testresult = activedocument.Evaluate("vTest")

msgbox(testresult)

end sub

Re: How to export formula with Set analysis using macro

Anonymous — Mon, 25 Sep 2017 11:27:36 GMT

I used the following

set testresult = ActiveDocument.Variables("vAging_WeeklyReport_LastWeek")

testresult= testresult.getcontent.string

testresult = activedocument.evaluate(testresult)