Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Total the expression columns based on dynamic dimension selection

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?

Tags (2)
1 Solution

Accepted Solutions
jykang0638
New Contributor III

Re: Total the expression columns based on dynamic dimension selection

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.

3 Replies
Not applicable

Re: Total the expression columns based on dynamic dimension selection

Load Col1,

Sum(Expr1) as Expr1,

Sum( Expr2) as Expr2

Group By Col1;

Not applicable

Re: Total the expression columns based on dynamic dimension selection

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
New Contributor III

Re: Total the expression columns based on dynamic dimension selection

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.

Community Browser