Tips and Tricks in QlikView

Mon, 06 May 2013 05:49:06 GMT

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.

Re: Tips and Tricks in QlikView

Lee_Matthews — Tue, 13 May 2014 23:49:02 GMT

Hi Anirban

This seems to be an old post. But in terms of Tips & Tricks, try the attached post:

QlikView How To (or Tips & Tricks) Application

Regards

Lee

topic Tips and Tricks in QlikView in QlikView

Tips and Tricks in QlikView

Re: Tips and Tricks in QlikView