5 Replies Latest reply: Nov 11, 2014 8:20 AM by Michael Tarallo RSS

    how to make qvd in qliksense

    erika gupta

      How to make qvd in qliksense?

        • Re: how to make qvd in qliksense

          The same way you would in QlikView, i.e. in the script (dataload editor in Qlik Sense) after a load statement:

           

          store <tablename> into <qvd name>.qvd (qvd);

          • Re: how to make qvd in qliksense
            Michael Tarallo

            Hi  Erika,

             

            The suggestion that Tim has provided is the correct step with the default settings in Qlik Sense.

             

            You must use the LIB syntax instead of the drive letter.

             

            You must have a folder connection created with a name that you will also reference in the LIB statement:

             

             

            Here is the correct syntax that should work for you - with a sample table:

             

            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 ;

             

            STORE ASCII into [lib://myFolder/Test1.qvd];

             

            Note: If you want to use the drive letter the way you would using QlikView- you must Disable Standard Mode (Qlik Sense Desktop)

             

            You can read up on that here:

             

            Hope this helps.

             

            These videos might also help you: New to Qlik Sense Videos

             

            Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.

             

            Regards,

             

            Mike Tarallo

            Qlik