topic Re: Comment Field in QlikView

Comment Field

pradeep92 — Tue, 28 Nov 2017 07:26:11 GMT

Hi,

Here is the sample code,

Transactions:

Load

TransLineID,

TransID,

mod(TransID,26)+1 as Num,

Pick(Ceil(3*Rand1),'A','B','C') as Dim1,

Pick(Ceil(6*Rand1),'a','b','c','d','e','f') as Dim2,

Pick(Ceil(3*Rand()),'X','Y','Z') as Dim3,

Round(1000*Rand()*Rand()*Rand1) as Expression1,

Round( 10*Rand()*Rand()*Rand1) as Expression2,

Round(Rand()*Rand1,0.00001) as Expression3;

Load

Rand() as Rand1,

IterNo() as TransLineID,

RecNo() as TransID

Autogenerate 1000

While Rand()<=0.5 or IterNo()=1;

Comment Field Dim1 With "This is a field comment";

What happens to the below mentioned line ? Why it is used ?

Comment Field Dim1 With "This is a field comment";

Anil_Babu_Samineni — Tue, 28 Nov 2017 07:30:48 GMT

This used for understand of each comment for Data model level.

woshua5550 — Tue, 28 Nov 2017 07:57:19 GMT

It is nothing but a comment in order to let different developers know the meaning of the field , you can find it here

pradeep92 — Tue, 28 Nov 2017 07:59:07 GMT

Thank you bro