Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Change selections in a export to excel macro

Hi

i'm exporting tables to an excel with this useful macro

Export to Excel for each dimension value as separate sheet

Now i have to export a object with a selected value, and the same object with other selected value

I tried with this

set val=ActiveDocument.Fields("_ARS").GetPossibleValues

ARS = val.Item(val.Count-1).Text

ActiveDocument.Fields("MEDIDA_DESCRIPCION").Select ARS


after the part of exporting the object:


aryExport(0,0) = "FISICOxMARCA"

aryExport(0,1) = "Fisico x MARCA ARS"

aryExport(0,2) = "A1"

aryExport(0,3) = "data"

.... ( new code)...

(and i created an inline like this)

LOAD * INLINE [

    _ARS, _UND,

    ARS, UND

];

But if i use this the macro stop working

Any ideas?

Thank you

1 Reply
Not applicable
Author

BTW: I know i could do it with more expressions with set analys, but they're a lot of objects.