topic Re: QV hangs after making a key from a resident table in QlikView

QV hangs after making a key from a resident table

tinkerz1 — Wed, 28 Oct 2015 18:19:31 GMT

QV is hangs when I add a key to my fact table.

What I am is doing is this

[Table1]:

Load *,

ORDERID and LOCATION AS KEY

SALESID and LOCATION AS KEY2

Calcfield as KEY3

Resident [TableA];

Drop TableA

But this is really not working its hanging really and won't continue I have identifed it as this code.

It works in the script but on smaller tables, the reason why I put the key on after is because its on a calculated field and also after a where clause so the data set is smaller.

Re: QV hangs after making a key from a resident table

quwok — Wed, 28 Oct 2015 18:24:25 GMT

It sounds like that piece of code may have added some complex relationship to your model. The "hanging" would most likely be QlikView trying to resolve it. Have a look and see if the addition of that code has created any circular references or complex synthetic keys to the model.

Re: QV hangs after making a key from a resident table

tinkerz1 — Wed, 28 Oct 2015 18:26:20 GMT

How do I do that as It hangs and wont finish??

Re: QV hangs after making a key from a resident table

tinkerz1 — Wed, 28 Oct 2015 18:29:26 GMT

I have renamed the field so there is no associations and still it hangs.

Re: QV hangs after making a key from a resident table

cwolf — Wed, 28 Oct 2015 18:30:45 GMT

"and" is here not correct. You have to use:

[Table1]:

Load *,

ORDERID & LOCATION AS KEY,

SALESID & LOCATION AS KEY2,

Calcfield as KEY3

Resident [TableA];

Re: QV hangs after making a key from a resident table

tinkerz1 — Wed, 28 Oct 2015 18:35:37 GMT

Yes I am using '&'

I am even using

[Table1]:

Load *,

'-' as test

Resident TableA;

Re: QV hangs after making a key from a resident table

tinkerz1 — Wed, 28 Oct 2015 18:39:57 GMT

Thinking out loud, by duplicating the table I am making many associations in the *, portion.

How can I add a key to table after I have added a calculated field and then reduced it by using a where clause?