Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Reduce Data: Keep Possible Values

Usage of the "Reduce Data: Keep Possible Values".

Is there an easy way to do some selection at the end of the load script, and then run the Reduce Data function?

Or do I have to use Macro to do this?

I have lots of garbage data that i need to remove after all the load is done.

Kind regards,
Kjetil

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Take a look at the KEEP script statement.

-Rob

View solution in original post

3 Replies
Not applicable
Author

You can use EXISTS() function in script to exclude unwanted data.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Take a look at the KEEP script statement.

-Rob

Not applicable
Author

Are there some other ways? Like macro? I have some shared script for more QV so I can't use keep. Can you help me, please?