load order of apply maps

[damien_burns]

Hi

I am running QLikview 12.2 alongside 12.4 for testing purposes.

In my reports there are small differences which I have traced back to the order in which some apply maps are loaded.

In there any reason why the would load the same tables in a different order and is there anything I can do to align them without having to rewrite the script?

Thanks

Damien

[rubenmarin · Accepted solution]

Hi Damien, I didn't found any reason and/or config value to keep old behaviour (wich doesn't means it doesn't exists, just that I haven't found it)

As you probably know Applymap returns the first match found, I always add the Order By clause to the mapping when is important that they load in a specific order, or even better keep the key field as unique values and only load the ones that should be returned.

[Brett_Bleess]

Damien, did Ruben's post help, or are you still working on things?  I checked the Initial Release Notes for both 12.30 and 12.40, but did not see anything that looked applicable there.  I checked defect system too, but I could not really find anything definitive, there are some references to other changes in the product that impact ApplyMap, so I think Ruben is likely on the right track with things.  If you figured something out, please consider posting that and then mark that as the solution, and if you are still working on things, leave an update.

Regards,
Brett

[damien_burns]

We didn't get to the bottom of the cause of the issue so we did just define some order by clauses to force the data to come through in a certain way

Thanks

Damien