Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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