Can anyone tell me what is the purpose of % sign here?

[ananyaghosh]

Hello friends,

I am new to QlikView and I have been assigned into a project for maintaing the Qlikview scripts. Can anyone tell me the the purpose of %

sign here in aggr() function?

=aggr(count({<[Prospect Appointment Flag] = {1}>}distinct ProspectNumber), [%Key Appointment Date])

ans also in

LOAD [%Key CC Prospect Number],

     Date([Prospect ActionDate]) as [Prospect ActionDate]

FROM $(vtmpQVD_Data)ActionDate_tmp.qvd (qvd)

Where not isnull([Prospect ActionDate]);

Thanks,

Sandip

[datanibbler]

Hi Sandip,

obviously that fieldname has the % sign as a prefix.

In our database, it seems that this is commonly used to denote keyfields. But it doesn't really make any difference in QlikView - and honestly, since there is no info as to what table can be linked using that keyfield, it isn't really helpful.

HTH

[MK_QSL]

There could be certain possibilities of using % sign in front of any Field.

1) Sometimes, you want to identify all key fields (primary fields) from other fields.

2) Sometimes, you are having temporary fields which is created to join certain tables but we do not want to show them as an available field... we can use Set HidePrifix = '%' in script. so all Fields starting with % would be hide.