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.