Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

qlikviewalex
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:

Dimension1Dimension2Expression1Expression2Expression2
=sum( {$<SalesYear={'2011'},>}  Sales)=???????=???????
ProductCustomer

Sales 2011


total Customers Sales 2011total Product Sales 2011

P1

C15 5+6=115+2=7

P2

C16 5+6=116+4=10
P1C22 2+4=65+2=7
P2C24 2+4=66+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
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
MVP

Re: use only parts from selections for the calculation

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

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

sushil353
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

qlikviewalex
New Contributor III

Re: use only parts from selections for the calculation

Thanks

qlikviewalex
New Contributor III

Re: use only parts from selections for the calculation

Thanks

Community Browser