1 Reply Latest reply: May 13, 2014 7:49 PM by Lee Matthews RSS

    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.