Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
kevinalvino
Partner - Creator
Partner - Creator

[QlikSense] Table Name Rule

Hi All.

I have a query regarding a table name.

For example :

a[TestName]:

Load * INLINE

[

a,b

1,2

];

Running this statement is resulting unknown error.

One thing for sure that the mistake is in the table name, because if i change the name into "a[TestName]" or [TestName] or TestName it will run.

The question is, Is there any table name rule regarding square bracket?

I'm using version June 2018. Previously i'm using June 2017.

Thanks,

Kevin

1 Solution

Accepted Solutions
jmmolero
Partner - Creator
Partner - Creator

Hi Kevin,

You could check the realese notes  of latest version of Qlik sense.

In theses documents you'll found "Bug Fixes" and "Known issues and limitations", it's posible that in new version a change was applied in table labels rules.

Regards

View solution in original post

7 Replies
kevinalvino
Partner - Creator
Partner - Creator
Author

Hi Jose,

Based on the provided link, Labels containing blanks must be quoted using single or double quotation marks or square brackets.


So, my table name not contains any blanks or space. So i think this still count in the range of stated rule.

But, there is a square bracket in the middle of the string (which usually, be used in front and the back of the string according to the stated rule). As I can't change anything, because this is the format and working on June 2017 Version and i interested behind this Unknown Statement Error.


I think there should be a technical preview available regarding this?


Thanks,

Kevin


agigliotti
Partner - Champion
Partner - Champion

the square brackets with table name are needed when you have spaces between words ex. [Table 1].

agigliotti
Partner - Champion
Partner - Champion

what's your table name in June '17 data model for that table ?

kevinalvino
Partner - Creator
Partner - Creator
Author

Hi Andrea,

As this is the format i'm using previously NameMap[TableName], i need to write also the Square Brackets even though there is no space. This issue can be solved using "NameMap[TableName]", but i'm more interested to is there any rule regarding this bracket square, as in June 2017 it still working.

Thanks,

Kevin

kevinalvino
Partner - Creator
Partner - Creator
Author

Hi Andrea,

Should be no different from the example.

Let's say that the format for the Table Name is :

NameMap[TableName]

Thanks,

Kevin

jmmolero
Partner - Creator
Partner - Creator

Hi Kevin,

You could check the realese notes  of latest version of Qlik sense.

In theses documents you'll found "Bug Fixes" and "Known issues and limitations", it's posible that in new version a change was applied in table labels rules.

Regards