topic Summing across a Row in QlikView

Summing across a Row

Fri, 08 Apr 2011 11:44:04 GMT

Can some one help with the expression I need to calculate Expr2, to create the table the user needs to select 1 year.

Dim1 >--> Quarter>--> 1

Dim2 >--> Month/Year >--> Jan-09 | Feb-09 | Mar-09

Expr1 >--> Value 1>--> 10 | 15 | 25

Expr2 >--> Value2>--> 10 | 25 | 50

Summing across a Row

deepakk — Fri, 08 Apr 2011 11:58:28 GMT

hi,

Tyr out the attach application

Summing across a Row

Fri, 08 Apr 2011 12:10:14 GMT

Sorry, maybe I was not clear I'm deriving Expr2 from Expr1

Summing across a Row

deepakk — Fri, 08 Apr 2011 12:16:21 GMT

hi,

You can do it in both ways... Either create at scrip level or fron end.. The current applications contains the front end part also... see the second pivot table.

Summing across a Row

Fri, 08 Apr 2011 12:38:18 GMT

Thanks, but when pivoted so with the Expressions are horizontal as the attached the 'Above' function does not work.

Summing across a Row

deepakk — Fri, 08 Apr 2011 13:37:39 GMT

hi Chris,

In Such Case use Before function instead of Above.