topic expression answer in QlikView

expression answer

Thu, 12 Apr 2012 22:25:26 GMT

hello,

i have a table with this data:

Year | Total

2001 | 2

2002 | 4

2003 | 6

i put this into a chart table and i need to make an expression on the line 2002 doing the follow thing:

Year | Total | Expresion

2002 | 4 | total2002/Total2001 - 1 = 1

2003 | 6 | total2003/Total2002 - 1 = 0,5

and so forth with a table of many more values

how would be this expression?

tnk's,

expression answer

swuehl — Thu, 12 Apr 2012 22:30:26 GMT

Try something like

=TOTALFIELD / above( TOTALFIELD ) -1

where TOTALFIELD is the field name which contains your total (or use sum(Value) if you need to calculate your total).

expression answer

Fri, 13 Apr 2012 00:55:16 GMT

thanks for your suggestion, it was useful for me....

the expression works to me with "before"

total/before(total)-1

expression answer

swuehl — Fri, 13 Apr 2012 09:10:46 GMT

Yes, right. You probably use a pivot table chart, then?

The chart inter record functions like above(), before() are depending on your dimension values orientation and sort order, so you must pick the right one for your needs (and take care for the case user changes sort order 😉