Special characters in Qlik Sense Scripts

Neha121 — Thu, 09 Nov 2023 23:35:03 GMT

Hi Team,

In below sample code I want to understand below few things..

1. % prefix in table name - when do we use %?

2. % prefix in field name - when do we use %?

3. # prefix in field name - when do we use #?

4. %% prefix in table name - when do we use %%?

5. IF(#d.Field1 <> PREVIOUS(#d.Field1), 1, PEEK([%Field5]) + 1) AS [%Field5] what will this Peek() statement do?

6. Are there any resources for learning theses complex scripts in Qliksense? If you can share the link it would be very helpful

Sample code

%Table1:
LOAD
#d.Field1,
Field2,
Field3,
Field4
FROM [xyz.qvd] (qvd)
;

%%Table1:
LOAD
#d.Field1,
Field2,
Field3,
Field4,
IF(#d.Field1 <> PREVIOUS(#d.Field1), 1, PEEK([%Field5]) + 1) AS [%Field5] //asc 1,2,...
RESIDENT %Table1;

Re: Special characters in Qlik Sense Scripts

rubenmarin — Fri, 10 Nov 2023 10:22:27 GMT

Hi, so far I know those prefixes doesn't meant anything unless there is another instruction that gives them an utility.

In example you can set HidePrefix = '#', and this will make fields starting by '#' to not appear on selections and some lists of fields.

The % used in the table name seems something the developer used to avoid to use the same table name, I will prefer to use the 'tmp' prefix and give a name with some meaning but it's just a naming metodology that each one decides.

Fields Named with # usually means a field used in counts, or more general for number, but again, it's just the name given by the developer.

topic Re: Special characters in Qlik Sense Scripts in App Development

Special characters in Qlik Sense Scripts

Re: Special characters in Qlik Sense Scripts