How to call next value in the table ?

[#1]

Hi All,

Need your assistance in doing this calculation?

Level	Headcount	Ratio
VP	10	=40/10
Director	40	=90/40
Sr.Manager	90	=148/90
Manager	148	=200/148
Assistant Manager	200	=530/200
Team Lead	530	=1900/530
Executive	1900	NA

I have written the calculation which i need to do in Ratio Column ?

Thanks in Advance!!

Regards

Anurag

[Gysbert_Wassenaar]

Temp:

LOAD Level, Headcount, recno() as recno FROM ...somewhere...;

Result:

LOAD Level, alt(Headcount, previous(Headcount)/Headcount,'NA') as Ratio

Resident Temp order by recno desc;

drop Table Temp;

[Josh_Good]

Anurag,

If you'd like to do this on a chart in the UI, you can use the Below function.  The Ratio expression would be:

Below(Sum(HeadCount)) / Sum(HeadCount)

This approach will require you to be careful about the sorting of the table.

-Josh

Qlik