Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

applymap

Hi!

I want to know if there's in some cases where you shouldn't use applymap. I have a datamodel where there's a few dimensions that only consists of two field. So my plan is to integrate them with the fact table.

Or can i screw things up doing that in some cases?

Thanks!

5 Replies

Hello,

I don't see any problem using ApplyMap other than a JOIN may perform better if your volume of data is high. Note that ApplyMap only allows two fields, and depending on your datamodel, this may not be enough or it may require to nest applymaps, and it may make the load slower...

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Not applicable

t

Partner
Partner

Apply maps only work for a 1 to 1 join as well.  So if the key can have multiple values you'd need to use a join.

Partner
Partner

Hi, Annika.

Have a look at Steve Dark's blog. It may help.

http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

Regards,

Neil

Specialist II
Specialist II

it based on primary key. so whenever you  don't have a primary key you are not able to use applymap

Regards