topic Re: Set Analysis Exclude in QlikView

Set Analysis Exclude

mazacini — Wed, 17 Oct 2012 08:04:57 GMT

I have 2 dimensions, ITEMCODE (which is a Product Code) and NAME ( a customer name), and a measure TR.VALUE.

I have a simple table with dimension NAME and expression Sum(TR.VALUE).

I want a table to show which customers have NOT bought a selected iproduct.

I tried this:

Sum ({$<NAME=E({1<ITEMCODE=>}NAME)>}TR.VALUE)

but this gives me an empty table.

Any ideas?

Re: Set Analysis Exclude

thomas_skariah — Wed, 17 Oct 2012 08:19:03 GMT

Hi,

Is it like there is a product code list box,and when the selection is made the chart should show all the customers which is not associated with the selected product code.Is it right?

Regards,

Tom

Re: Set Analysis Exclude

mazacini — Wed, 17 Oct 2012 08:22:26 GMT

Yes, there is a product list box.

And, yes, I think you have described the requirement correctly - maybe I don't need the expression?

Re: Set Analysis Exclude

thomas_skariah — Wed, 17 Oct 2012 09:16:42 GMT

Hi,

You can use the attached application.

Hope it works.

Regards,

Tom

Re: Set Analysis Exclude

mazacini — Wed, 17 Oct 2012 09:20:59 GMT

Hi Tom

Many thanks - but I only have PE.

Could you describe solution?

Joe

Re: Set Analysis Exclude

swuehl — Wed, 17 Oct 2012 09:45:04 GMT

You should be able to do what you want using the select excluded feature in the list box context menu on NAME list box.

If you want to do this in a table, automatically, you could create a straight table with dimension NAME and as expression:

Sum ({$<NAME=E(), ITEMCODE=>} TR.VALUE)