Field Names starting with "%" sign

[Rich5678]

Hi,

I am working with a Qlik Sense application that was built by someone, who is not with our company anymore.

In the Fields list on Sheet Tab, I see some Fields that start with a %sign.

For example "%BusinessDate". For example, in this field, I don't see Business Dates, but I see a sequence of numbers from 1 to 25,000 (apparently looks like a Row Number within the table).

Is there any special significance to these Field Names that start with % sign?

Thanks.

[JordyWegman · Accepted solution]

Hi Rich,

We use the % to mentioned 'key fields' in a table. That are the fields we link other (dimensional) tables to. The 1 to 25.000 are the numerical numbers of a date. Enter a date in Excel, say today, and create a number of that field. You will see it will says 44788:

So your %BusinessDate is used to say, this the important date field of this table. And you can link a calendar to see all related data on different date levels (days/weeks/months/years).

Jordy

Climber

[Rich5678]

Many thanks