topic Re: how to exclude several items from one group? in QlikView

how to exclude several items from one group?

Mon, 27 Jan 2014 12:54:25 GMT

Hi,

I have a product group ('Group A') that consists of 100 products. I want to exclude 5 products out of this group and create a group without those products ('Group A-').

Can anyone suggest how to create such a group at the script level?

Thanks

Thomas

Re: how to exclude several items from one group?

alexandros17 — Mon, 27 Jan 2014 12:58:28 GMT

LOAD

....

myProduct,

if(myProduct = 'exl1' or myProduct = 'exl2' ..... , 'E', 'I') as flag exclude

....

In this way you can use the flag to identify product you need, and

you can use the flag in all the expressions even list box

Hope it helps

Re: how to exclude several items from one group?

Mon, 27 Jan 2014 13:01:14 GMT

T_Map:

Mapping load

ProductId,

'A-' as Group

resident Yourfile

WHERE ProductId in (11,22,33,44,55) (for example)

LOAD

applymap('T_Map', ProductId, '?') as Group

From yourfile;

You can also manage a specific file or LOAD * INLINE from these products

best regards

Chris