topic Re: Computing Variances using Sum function in QlikView

Computing Variances using Sum function

Tue, 21 Apr 2015 15:19:28 GMT

I'm attempting to create a column that displays the difference between two columns utilizing the sum function. I am able to compute successfully as independent expressions, but when attempting to put them in a single expression I render no results.

The expression is written as follows:

(=Sum({$<[BS Date]={"$(=Date(Max([BS Date])))"}>}[Total Adjusted Fair Value]) -

(=Sum({$<[BS Date]={"$(=addyears(Date(Max([BS Date])),-1))"}>}[Total Adjusted Fair Value])

Am I missing something here?

Re: Computing Variances using Sum function

Tue, 21 Apr 2015 15:38:49 GMT

The first line of the expression calculates the Total Adjusted Fair Value for the Date = 12/31/14. The second line of the expression calculates the Total Adjusted Fair Value for the date one year prior, 12/31/13.

Re: Computing Variances using Sum function

marcus_malinow — Tue, 21 Apr 2015 15:41:19 GMT

Just a syntax error

Your expression needs to lose the first equal signs before the Sum, within the parentheses

=(Sum({$<[BS Date]={"$(=Date(Max([BS Date])))"}>}[Total Adjusted Fair Value]) -

(Sum({$<[BS Date]={"$(=addyears(Date(Max([BS Date])),-1))"}>}[Total Adjusted Fair Value])

Re: Computing Variances using Sum function

Tue, 21 Apr 2015 15:49:33 GMT

Marcus,

Thanks, that worked.

Re: Computing Variances using Sum function

marcus_malinow — Tue, 21 Apr 2015 15:51:18 GMT

Not a problem, happy to help.

Thanks for marking my answer correct