5 Replies Latest reply: Jul 24, 2015 5:10 AM by Alexander Steinhart

# use only parts from selections for the calculation

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( {\$}  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

• ###### Re: use only parts from selections for the calculation

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

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

• ###### Re: use only parts from selections for the calculation

Thanks

• ###### Re: use only parts from selections for the calculation

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

• ###### Re: use only parts from selections for the calculation

Thanks

• ###### Re: use only parts from selections for the calculation

Hello Alex,

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

Have fun

JP