Total the expression columns based on dynamic dimension selection

[#1]

I have a straight table with 4 dimensions that can be dynamically chosen by user to be displayed using a list box. There are 2 expressions.See sample below

Col1     Col2     Col3     Col4     Expr1     Expr2

A     A1     A11     A111     10     20

A     A1     A12     A121     10     20

A     A2     A21     A211     10     20

A     A2     A22     A221     10     20

B     B1     B11     B111     10     20

B     B1     B12     B121     10     20

B     B2     B21     B211     10     20

If user only choses Col1 to be displayed, I would like the number of rows to be reduced to 2 and display as below

Col1     Expr1     Expr2

A     40     80

B     30     60

Can someone provide some direction?

[#2]

Load Col1,

Sum(Expr1) as Expr1,

Sum( Expr2) as Expr2

Group By Col1;

[#3]

Antonio - like I indicated the column selection is dynamic ,so the user may chose any combination of col1,col2,col3, or col4. I want the aggregation to occur dynamically

[jykang0638 · Accepted solution]

Hi Aya,

What is the QV version you are using?
If you are using V11, it's very simple.
You can use Conditional Enablement on both Dimension and Expression.
Refer to related example - Whats New in QlikView11.qvw.