topic Re: circular key in QlikView

circular key

Mon, 20 May 2013 08:04:42 GMT

I need to present the profit margin per item, to link the purchase documents with the calendar does not offer true results, and to make script recharge occurs circular key the article and date code. Not as out of here, please need help.

I present the structure of tables

Re: circular key

nizamsha — Mon, 20 May 2013 08:13:01 GMT

most of the time i will rename any one of the field it will work u can try it and check the result.

Re: circular key

vikasmahajan — Tue, 21 May 2013 12:17:40 GMT

This is due to some common fields in your data model , try to rename as per Mr.Nizmsha suggested and additional you can joins tables fields as per your requirements to avoid common fields.

Vikas

Re: circular key

er_mohit — Tue, 21 May 2013 12:56:00 GMT

use qualifier *; before table loaded

or you can use Qualifier A,B ; as wirte those fields which are common in both table

TestA:

load A,

C from ......;

qualifier B,C;

TestB:

load A,

C ,

from .......;

Doing this,it gives you primary link with A field name and remove the circular key

hope it helps

Re: circular key

Wed, 22 May 2013 06:27:33 GMT

Thanks for the replies.

These solutions and had in mind, the problem is that if I link sales or purchases with the calendar not take well to date, and if the articles I link to is exactly the same, do not pick the item up.

regards