topic Table headings from script show as prefix for table names?? in QlikView

Table headings from script show as prefix for table names??

Tue, 09 Aug 2011 13:14:39 GMT

Hello Experts,

I have a general question about setting up the environment before starting development. I am working on an existing app developed by someone else and when I add a new table in the script, it shows with the Tablename as Prefix and then the field names. Please check below:

FctKPI:

Load * INLINE [

KPI_Test, Measure

1,Test

2,Full,

3,Half

and so on....

When I look at fields KPI_Test, it shows as FctKPI.KPI_Test , similarly it shows Measure as FctKPI.Measure I am unable to find a way to change this in the settings.. can anyone help?

Thanks in Advance,

Mady

Table headings from script show as prefix for table names??

Tue, 09 Aug 2011 13:46:04 GMT

Is this because, I am getting the data from Views instead of Tables??

Any suggestions guys?

Thanks again

Re: Table headings from script show as prefix for table names??

its_anandrjs — Tue, 09 Aug 2011 13:54:37 GMT

Hi mady,

I thing in your code below FctKPI: a Qualify *; command is kep there you thats why your code gets concatenated by the table name FctKPI: to each fields you need to remove it or check it is for another purpose or not otherwise you remove it.

If its purpose is not there so you just put that code Qualify *; after the completion of load script of this table.

Regards,

Anand