Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

apalmtree
Contributor 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!

Tags (2)
5 Replies

applymap

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

Re: applymap

t

jpapador
Valued Contributor

Re: applymap

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.

ngulliver
Valued Contributor III

Re: applymap

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

techvarun
Valued Contributor II

Re: applymap

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

Regards