Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.