Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Coloful_Black
Contributor III
Contributor III

qlik sense short cut___ctrl + 00

Hi gurus

Trying to self educate Qlik sense with the guideline doc for keyboard shortcut.

I find there is one for Ctril + 00 

the description says it is for Inserting a test script in the data load editor.

 

and I used it to one of my Qlik sheet load editor...

 

it returns me 

-------------------------------------------------------

 

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

-------------------------------------------------------------------------------------------

 

wanted to better understand this ...anyone who can help elaborate a bit more about  what this is ?

 

thanks 

1 Reply
Wlad_Masi
Former Employee
Former Employee

Hi @Coloful_Black ,

 

This shortcut helps you to create quick data very useful for testing purposes.
This article explains a bit more about this shortcut: How to create a small sample data set in QlikSense using a Ctrl+0+0 shortcut

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.