Guys,
If anybody has some knowledge of the hidden internal things QlikView can do for you or has some tips and tricks to share, please reply to this post. I am sharing my first point.
1. Autmatic data generation within QlikView script
Once you are in the Edit Script window, you can generate data within QlikView for a quick and dirty testing purpose by just pressing Ctrl+q+q (press 'q' twice while holding Ctrl). QlikView will automatically generate the following lines of code:
Characters:
Load Chr(RecNo()+Ord('A')-1) as Alpha, RecNo() as Num autogenerate 26;
ASCII:
Load
if(RecNo()>=65 and RecNo()<=90,RecNo()-64) as Num,
Chr(RecNo()) as AsciiAlpha,
RecNo() as AsciiNum
autogenerate 255
Where (RecNo()>=32 and RecNo()<=126) or RecNo()>=160 ;
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";
The first load, i.e. Characters load the alphabet (A-Z) and their corresponding serial number (1-26).
The second load, i.e. ASCII loads the characters along with special character and integers and their corresponding ASCII values.
The third load, i.e. Transactions loads 3 sample dimensions, 3 sample expressions and sample transaction data.
Please note, these are the system fields which becomes visible when you check the 'Show System Fields' checkbox in the properties window of a relevant chart object.
.png "Former Employee"){kind=icon}