Select a sub-set of items

[burgersurfer]

Hi

I have a QVW with sales information across about 28,000 products. I want to limit the QV report to a sub-set of these items, as defined in a separate list. This list can be loaded as an inline or Excel load, but Excel will probably be better.

How do I define a table/graph/object that selects only the products on my list?

Thanks.

[Oleg_Troyansky]

Load the list of "selected" items and identify a "flag" - a field that gets a number 1 for the Selected Items and null() for all others.

With the Flag defined, you can use it in Set Analysis within your expressions:

sum( {<SelectedFlag = {1}>} SalesAmount)

[#3 · Accepted solution]

Hi Burger Surfer,

I did not fully understand your question. But I hope this might help you. Just group your products according to your group category in an excel sheet and then load this excel sheet into your QV application. Now this acts as an mapping table to the different product groups in your sales sheet. So now by using the respective group names you will be able to solve your issue. Hope this helps.

best Regards Joseph

[burgersurfer]

THanks, I think both points to the same answer, I did not know how to define the "flag" but got it working with this.

BS