Discussion board where members can get started with Qlik Sense.
Need your assistance in doing this calculation?
I have written the calculation which i need to do in Ratio Column ?
Thanks in Advance!!
LOAD Level, Headcount, recno() as recno FROM ...somewhere...;
LOAD Level, alt(Headcount, previous(Headcount)/Headcount,'NA') as Ratio
Resident Temp order by recno desc;
drop Table Temp;
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.