use only parts from selections for the calculation

[qlikviewalex]

Hi,

I'm new her. I hope it's the correct place for my question.

I have a 'Straight Table' with two dimensions. And I need 3  Expressions. You can see a example her:

Dimension1	Dimension2	Expression1	Expression2	Expression2
		=sum( {$<SalesYear={'2011'},>}  Sales)	=???????	=???????
Product	Customer	Sales 2011	total Customers Sales 2011	total Product Sales 2011
P1	C1	5	5+6=11	5+2=7
P2	C1	6	5+6=11	6+4=10
P1	C2	2	2+4=6	5+2=7
P2	C2	4	2+4=6	6+4=10

Row one and two are for explanation.

My problems are the formulas for expression 1 and 2 

There should be no influence of Listboxs to my Expressions. Only in Expression1 is it ok.

I hope you can help me. Thanks

Alex

[swuehl · Accepted solution]

=sum(TOTAL<Customer>  {1<SalesYear={'2011'}>}  Sales)

=sum(TOTAL<Product>  {1<SalesYear={'2011'}>}  Sales)

[sushil353]

Hi,

If you dont want to interact with list box then in your expression you can bypass then like:

=sum( {$<SalesYear={'2011'},Month=,Dim1=,Dim2=>}  Sales)

HTH

sushil

[#4]

Hello Alex,

welcome to the show, Best place to post this would be in "NEW TO QLIKVIEW"

Have fun

JP

[qlikviewalex]

Thanks

[qlikviewalex]

Thanks