topic Resident in QlikView

Resident

Tue, 12 Oct 2010 12:37:14 GMT

Hi,

I am getting the error while trying to use the resident .

a. I am loading the data from database through the select statement .

b.After load statement i have used the Cross table and converted the columns to rows.

Till this it is working fine.

Now i trying to manipulate the crosstable data .since it is loaded in memmory i am trying to using the Resident keyword to access the loaded data. but i am getting error as table not found at the resident code. please find the code ia have used.

TEMP:

crosstable(dtype,Dte,2)

Load

CNO,

CTNO,

LTM,

CTM;

SQL SELECT

CUID as CNO,

TICKETNO As CTNO,

LOGGEDTIME As LTM,

CLOSEDTIME As CTM

FROM test Where CUID in ('1','2','3','4');

TEMP1:

Load

CNO,

CTNO,

DTYPE,

DTE,

YEAR(DTE),

MONTH(DTE)

RESIDENT TEMP;

Resident

Tue, 12 Oct 2010 14:05:28 GMT

I think it might be that as you are using a preceding load that the resident table created as a result of the SQL statement has an internal name and the load proper is also associated with that name. Run the script in debug and step through it and see what table name is being created or use an 'exit script' after the SQL statement then see what 'table viewer' shows.

Regards,

Gordon

Resident

Tue, 12 Oct 2010 15:13:53 GMT

Hi gordan,

Thanks for your response. And i mistakenly updated the error as Table not found. But the Actual error is field not found in the Resident Query......

Resident

Tue, 12 Oct 2010 15:48:16 GMT

HI,

The fieldname DTYPE in the last load does not exist. It should be dtype. (Qlikview is case-sensetive)

Resident

Tue, 12 Oct 2010 18:39:54 GMT

Hi daniel,

Thats true Qlikview is case sensitive. i have changed accordingly and it is working fine now.................

thanks for your response................