How to create a small sample data set in QlikSense using a Ctrl+0+0 shortcut

[Sonja_Bauernfeind]

To create a sample document follow below steps. The steps can be applied to all editions of Qlik Sense, such as Qlik Sense Enterprise on Windows and Qlik Sense Business and SaaS.

1. Open Sense (Hub or Desktop) and create a new application
2. Choose Script editor 
   
   

    

3. Press the following key combination: CTRL 0 0
4. This generates an automatic script with random data:
   
   

    

   Content:
   
   

   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";​

5. Click Load Data 
6. This loads in a very simple data model that can be used to test the basic functionality of Qlik Sense.

 

[QFabian]

awesome @Sonja_Bauernfeind ! remembering QlikView script menu feature