topic Re: Simple question from newbie - using expressions by reference in QlikView

Simple question from newbie - using expressions by reference

Thu, 08 Nov 2012 14:47:00 GMT

Hi!

Help me please in my simple question.

I've placed plain table on the sheet. I've added one dimension "Name" and, for example, to expressions "Sum1" and "Sum2":

- sum(A + B + C)

- sum(D + E)

Now i want place one more expression, that will sum two previous. Yes, i can write sum(A + B + C + D + E), but is that possible to use some references to that previous expressions - by name or id?

Like Sum1 + Sum2 or like GetRefValue(1) + GetRefValue(2)

Thanks!

Re: Simple question from newbie - using expressions by reference

MayilVahanan — Thu, 08 Nov 2012 14:53:04 GMT

Try like this

Column(1) + Column(2)

column1:sum(A+B+C) i.e expression1

column2: sum(D+E) i.e.expression2

Its calculate sum(A+B+C) + Sum(D+E) and give the result

Hope it helps

Re: Simple question from newbie - using expressions by reference

jonathandienst — Thu, 08 Nov 2012 14:59:07 GMT

In a straight/pivot table or chart you can refer to the results of the other expressions using Column(n), where n is the expression number (starting with 1).

You can also refer to the columns by referencing the column titles, for example:

[Sales this month]: your expression for sales this month

[Sales last month]: your expression for sales last month

[% Change]: ([Sales this month] - [Sales last month]) / [Sales last month]

[% Change]: (Column(2) - Column(1)) / Column(1)

Hope that helps

Jonathan

Re: Simple question from newbie - using expressions by reference

Thu, 08 Nov 2012 15:04:00 GMT

So simple... Thank you!