# QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

New Contributor III

## 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

1 Solution

Accepted Solutions
MVP

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

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

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

5 Replies
MVP

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

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

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

Honored Contributor II

## 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

Not applicable

## 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

New Contributor III

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

Thanks

New Contributor III

Thanks