Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to create rolling rank in Qlik Scripting?

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 :

DateAssetIDParameterRank
21/06/201711251
21/06/201721262
21/06/201731262

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 Type1RankAsset Type2Rank
1122
32

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.