topic Select a sub-set of items in QlikView

Select a sub-set of items

burgersurfer — Sun, 09 May 2010 20:09:40 GMT

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.

Select a sub-set of items

Oleg_Troyansky — Sun, 09 May 2010 23:18:31 GMT

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)

Select a sub-set of items

Mon, 10 May 2010 06:42:40 GMT

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

Select a sub-set of items

burgersurfer — Mon, 10 May 2010 16:04:29 GMT

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