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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

keep possible values macro

Hi everyone

     is there a way to keep possible values in macro?

thanks for any ideas!

SUB KeepPossibleOnly

ActiveDocument.Fields("Stredisko.Popis").Select "B2B"

'FILE->File->Reduce Data->Keep Possible Values.

END SUB

1 Solution

Accepted Solutions
morgankejerhag
Partner - Creator III
Partner - Creator III

Does ActiveDocument.ReduceData do what you want? If you have a selection before calling the function it behaves like Keep Possible Values.

View solution in original post

6 Replies
morgankejerhag
Partner - Creator III
Partner - Creator III

Does ActiveDocument.ReduceData do what you want? If you have a selection before calling the function it behaves like Keep Possible Values.

Not applicable
Author

Indeed, ActiveDocument.ReduceData will keep possible values.

If you want to remove all values from document you'd write:

ActiveDocument.RemoveAllData

Not applicable
Author

Thanks, that's it. Is there any documentation where I can find this? Something like java api for java or msdn for C#

Not applicable
Author

You can find helpful info in the APIGuide.qvw.

Under Automation Examples tab, search for object properties and you can find how to write them in the macros.

Not applicable
Author

Thanks, that was what I looking for

hectorgarcia
Partner - Creator III
Partner - Creator III

thanks very usefull (specially when you are re generating data based on binary loads