Union of Two Dimensions/Straight Table

[#1]

I have a very unique request. My dataset looks like following:

Customer	Product	Sales
A	X	$ 10
A	Y	$ 5
B	X	$ 5

I am creating two straight tables from this.

1) In this I want to look at Customers who bought X but did not buy Y. The output looks like following:

Customer	Sales
B	5

2) In this I want to look at Customers who bought X and also bought Y but less than $10. The output looks like:

Customer	Sales
A	5

The dimensions/expressions used in the above tables are completely different. I want to show a common output for both the tables above:

Customer	Sales
A	5
B	5

Is this doable in QlikView at all?

Thanks,

Sagar

[bumin]

you can create different charts with set analysis commands doing what you want.

[#3]

Bumin, I already have created two separate charts (straight tables) to obtain Output 1 and Output 2 described above.

I want them to be clubbed in a single straight table.

[sundarakumar]

You can show them like

cust    exp1     exp2

a          5    

b                        5

but what i think is they cannot be clubbed together if a same customer will fall  under both the categories.

-Sundar

[#5]

So in the result you want to see sum of sales of product X for those, who bought a zero amount of Y and sum of sales of product Y for those, who bought Y but the sum is less than 10? And what to do with those who bought, say sum of X = 100 and sum of Y = 20? Drop them?

[bumin]

try this, it should do what you want

[#7]

There's a flaw, IMHO. Add line C, Y, 8 to the inline load and it will go to the result table, but shouldn't (Customer C did not buy any amount of X)

[#8]

try this as well