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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Difference between QVD and TEXT

Hi,

In Edit Script,  I am trying to create the QVD and TEXT file by using Store command.

After completion of execution and when i opened the Cus2 Text File , then it is showing like Xml Format. 

IF we go through with MACRO Code for creating TEXT file then it is showing in  different format.

//EDIT SCRIPT EXECUTION

Customers:

LOAD Address,

    City,

    CompanyName,

    ContactName,

    Country,

    CustomerID,

    DivisionID,

    Fax,

    Phone,

    PostalCode,

    StateProvince;

SQL SELECT *

FROM Customers;

Store Customers into Cus1.qvd;

Store Customers into Cus2.txt;

//MACRO SCRIPT EXECUTION

sub MyText

    set vQvWorkPath = ActiveDocument.Variables("vQvWorkPath")

    set obj = ActiveDocument.GetSheetObject("TB02")

    set vBMname = ActiveDocument.Variables("vBook")

    obj.Export vQvWorkPath.GetContent.String&replace(Date(),"-","")&"_"&replace(Time(),":","")&".txt",","

    MsgBox("Data Has Been Transfered")

end sub

NOTE:

What is the main difference between Creating a QVD and TEXT in Edit Script, and what is the performance difference.

Thanks in advance

1 Reply
kji
Employee
Employee

You need to specify file format as txt, just giving a filename.txt is not enough, use:

Store Customers into Cus2.txt (txt);