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

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

ananyaghosh — Thu, 02 Apr 2015 07:21:47 GMT

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

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

datanibbler — Thu, 02 Apr 2015 07:29:12 GMT

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

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

MK_QSL — Thu, 02 Apr 2015 07:33:32 GMT

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.