Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

How to call next value in the table ?

Hi All,

Need your assistance in doing this calculation?

LevelHeadcountRatio
VP10=40/10
Director

40

=90/40
Sr.Manager90=148/90
Manager148=200/148
Assistant Manager200=530/200
Team Lead530=1900/530
Executive1900NA

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

Thanks in Advance!!

Regards

Anurag

2 Replies
MVP & Luminary
MVP & Luminary

Re: How to call next value in the table ?

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;


talk is cheap, supply exceeds demand
Employee
Employee

Re: How to call next value in the table ?

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

Community Browser