Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

mazacini
Contributor III

Set Analysis Exclude

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?

1 Solution

Accepted Solutions
MVP
MVP

Re: Set Analysis Exclude

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)

5 Replies
thomas_skariah
Contributor III

Re: Set Analysis Exclude

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

mazacini
Contributor III

Re: Set Analysis Exclude

Yes, there is a product list box.

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

thomas_skariah
Contributor III

Re: Set Analysis Exclude

Hi,

You can use the attached application.

Hope it works.

Regards,

Tom

mazacini
Contributor III

Re: Set Analysis Exclude

Hi Tom

Many thanks - but I only have PE.

Could you describe solution?

Ta

Joe

MVP
MVP

Re: Set Analysis Exclude

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)

Community Browser