Qlik Community

Ask a Question

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Tips and Tricks in QlikView

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.

1 Reply
Employee
Employee

Hi Anirban

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

QlikView How To (or Tips &amp; Tricks) Application

Regards

Lee