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

Print-Macro with additionally values

Hello,

i've created a macro for printing data out of an table.

This works fine and i do this like this:

set tObjSrc      = ActiveDocument.GetSheetObject(tObjID)

call tObjSrc.GetSheet().Activate()

ActiveDocument.GetApplication.WaitForIdle

tObjSrc.Export tDirectory & tFilename, ";"

QLikView creates a file in the given directory with the give filename.

The file like this:

row1;   row2;    row3;

test;     1;          12.12.2001;

one;     33;        01.04.2003;

two;      12;       06.04.1999;

Now i get all data with the selected abilities, but i want to get an extra row with an value (like 1) that shows, if the member do have this selected abilities.

After that i invert the selection and i get all members they dont have this abilities. They get also an extra value like 0.

How can i do this ?

Can anyone help ?

Thank you very much!

Manic.

0 Replies