topic Can we reduce data by selecting EXCLUDED values instead of Included values? in QlikView

Can we reduce data by selecting EXCLUDED values instead of Included values?

Mon, 26 Jan 2026 18:19:17 GMT

We want to reduce the data to a new published QVD and I know how to do this and it works, but lets say I want to only exclude 1 market do I really have to click on each market to select the included ones?

If that's the case I probably need to use section access to reduce the data set.

The Reduce tab shows this

"Creates one document. All data not included in the selection will be removed. "

Thanks

-Dan

Can we reduce data by selecting EXCLUDED values instead of Included values?

Miguel_Angel_Baeyens — Mon, 11 Apr 2011 19:08:25 GMT

Hello Dan,

What about clicking on the market you want to include and right clicking on "Select excluded" instead of selecting each of the excluded values? You can use a button with an action for that, or use an EXISTS() function in your WHERE clause...

I don't see any reason to use section access here if it's not something related to security.

Hope that helps.

Can we reduce data by selecting EXCLUDED values instead of Included values?

Mon, 11 Apr 2011 19:15:17 GMT

Unfortunately that is not an option in Qlikview Enterprise Management Console for data reduction.

You cannot right click and choose excluded like you can in a selection box.

Select all is available when you right click but does nothing.

Can we reduce data by selecting EXCLUDED values instead of Included values?

Mon, 11 Apr 2011 20:16:51 GMT

I think what Miguel is suggesting is feasible - he's saying to incorporate some comparisons in your script, as opposed to built-in functionality out of the box.

Can we reduce data by selecting EXCLUDED values instead of Included values?

ashfaq_haseeb — Tue, 12 Apr 2011 07:33:19 GMT

Hi Dan

What mrigun said is exactly correct.

However if at all you want to do it by QEMC.

then you need to have publisher with you.

where in publisher will create a separate file for your excluded values and a separate file for the included ones.

Hope that helps

Regards

ASHFAQ