Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
hazimalif17
New Contributor III

Re: Aggr and Rank in Load Script

Based on information provided by Omar and Kevin,

I came out with a solution

newtable:

Load

[Factory],

    [Total Complaint Received],

    if([Total Complaint Received] = 0, 1,

    if([Total Complaint Received] = peek([Total Complaint Received]), peek(Rank), recno()-1)) as Rank

Resident maintable,

Order by [Total Complaint Received]

Thank everyone!!!

omarbensalemksomosera10

ksomosera10
Contributor II

Re: Aggr and Rank in Load Script

Goood!

Glad to help!