How to create rolling rank in Qlik Scripting?

Sun, 23 Jul 2017 15:28:48 GMT

Hi All,

I have to create rolling rank in Qlik scripting itself and need to pivot the data in the script itself.

For example below is the data :

Date	AssetID	Parameter	Rank
21/06/2017	1	125	1
21/06/2017	2	126	2
21/06/2017	3	126	2

Now I understand that this can be achieved by Autonumber. But I have another challenge that, every asset have a type. So the rank should be set to one for each change of the type.

That means for each day, every asset have a rank from 1 to XXX. For now I have run a loop to do that. That is extremely slow. Any solution for bulk operations? Please help.

Finally I need the data in below fashion :

Asset Type1	Rank	Asset Type2	Rank
1	1	2	2
3	2

Using pivot will not allow this in the visualization because for the associations there will be blank in the related columns. Please let me know for any further clarifications.

topic How to create rolling rank in Qlik Scripting? in QlikView

How to create rolling rank in Qlik Scripting?