topic Re: key creation in QlikView

key creation

priyarane — Tue, 14 Jun 2016 15:24:47 GMT

Hi Community,

We have data like below

Based on the above data we have created pivot data like below

Now challenge is, I need to create a key for associaton between 3 tables (3 is another table, from there we are getting values) to get account name. Key column is Account code. so how to to create key, some one can pls help me.

- Priya

Re: key creation

vikasmahajan — Wed, 15 Jun 2016 07:34:12 GMT

Parent Account Code & '-' & Account Code as Key create this key while loading 3 tables.

Vikas

Re: key creation

priyarane — Wed, 15 Jun 2016 09:23:42 GMT

but here we are taking only under A000000_IAS account codes in the second table...

Re: key creation

PrashantSangle — Wed, 15 Jun 2016 09:45:48 GMT

Hi,

It is difficult to suggest with limited information.

we don't know what type of data other 3 tables contain.

from above 2 table which table you are loading in qv?

Please elaborate you requirement to get solution.

Regards

Re: key creation

priyarane — Wed, 15 Jun 2016 10:51:32 GMT

These 2 excel and one more table from Database....first table which we got from customers and second which we have created as per the requirements... account code is the key column between DB and first excel table... but we have created second table which have Paren, Child1, Child2.....etc... so here how to create association between created excel (second table) with Database and first excel table....

Re: key creation

Anonymous — Thu, 16 Jun 2016 10:11:27 GMT

As you are saying that your 1st table is already associated with DB table . then if you create association between 2nd table to DB table & 1st Table . It'll lead to Circular Loop .

Re: key creation

priyarane — Thu, 16 Jun 2016 14:46:04 GMT

I have got solution, thanks for you time

Re: key creation

Anonymous — Fri, 17 Jun 2016 02:26:14 GMT

Can you share your solution please .

Re: key creation

priyarane — Fri, 17 Jun 2016 12:05:50 GMT

key should be based on last column and to get desc, I have used Apply map