topic Re: Associate field in QlikView

Associate field

pgalvezt — Wed, 12 Mar 2014 18:18:35 GMT

Hello,

I have a table with account organization, And I need to create a new visualization structure. Actually I have SubAccount (Cods and names) And I need to group those fields: Propose name doesn't exist so I need to creat them and Group the subaccounts. The first part is ready.

I attached an example for better comprehenssion.

Thanks!

Re: Associate field

stevedark — Wed, 12 Mar 2014 21:01:07 GMT

I'm not sure what it is you are unable to do here. If you load in two tables and there is a common field name between them (right down to the case of the field name) then they will automagically associate on load.

You can get cleverer with your associations by using functions such as the ApplyMap function, which will allow you to 'swap out' a key for a different value. It can also allow you to map on an account structure - for example.

I have written a blog on ApplyMap that you can search for. I will post a link here, but it may take a while to go through moderation.

Hope that helps,

Steve

Re: Associate field

stevedark — Wed, 12 Mar 2014 21:02:11 GMT

The URL for the ApplyMap blog post referenced above is:

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

Re: Associate field

pgalvezt — Wed, 12 Mar 2014 21:17:55 GMT

Hi Steve,

I Created a 2 Inline with 3 fields and works perfectly. Anyway thank you for reply this question.

Thanks!!