How to generate new field in the back end

[rkpatelqlikview]

Hi Qlik,

Please explain on this.

I do have a fields "Safety Category" and Kms Travelled. I used this below calculation in the frond end text object.

=Ceil(sum({<[Safety Category]={'Green'}>} [Kms Travelled]) / sum([Kms Travelled]) *100) & '%'

Instead of writing above set analysis, i need to generate new field with above calculation. Please let me know the code.

Thanks in advance

[sunny_talwar · Accepted solution]

May be like this in a separate table:

KPITable:

LOAD Ceil(Sum(If([Safety Category] = 'Green', [Kms Travelled]))/Sum(Kms Travelled])*100) & % as Ratio

Resident .....;

[rkpatelqlikview]

Many Thanks Sunny.