topic Re: Total the expression columns based on dynamic dimension selection in QlikView

Total the expression columns based on dynamic dimension selection

Wed, 09 May 2012 14:53:29 GMT

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?

Re: Total the expression columns based on dynamic dimension selection

Wed, 09 May 2012 15:00:53 GMT

Load Col1,

Sum(Expr1) as Expr1,

Sum( Expr2) as Expr2

Group By Col1;

Re: Total the expression columns based on dynamic dimension selection

Wed, 09 May 2012 15:31:57 GMT

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

Re: Total the expression columns based on dynamic dimension selection

jykang0638 — Wed, 09 May 2012 15:54:19 GMT

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.