Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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