Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=sum(TOTAL<Customer> {1<SalesYear={'2011'}>} Sales)
=sum(TOTAL<Product> {1<SalesYear={'2011'}>} Sales)
=sum(TOTAL<Customer> {1<SalesYear={'2011'}>} Sales)
=sum(TOTAL<Product> {1<SalesYear={'2011'}>} Sales)
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
Hello Alex,
welcome to the show, Best place to post this would be in "NEW TO QLIKVIEW"
Have fun
JP
Thanks
Thanks