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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jagannalla
Partner - Specialist III
Partner - Specialist III

Missing fields of table box while creating qvd file for the table box

Hi,

I have added all my fields into one table box. And return a macro in button to generate qvd file but when i'm loading the qvd file i'm missing last fields of table box in the qvd file.

Macro code is :

Sub QVDFile                                              

    set obj = ActiveDocument.GetSheetObject("TB05") 

    obj.ExportBiff "D:\2_QVDGenerator\QVD\MyQvd.qvd" 

'    MsgBox("Data Has Been Transfer into QVD ")

    End Sub

- Plz help me y it is not creating last fields of table box into qvd file

12 Replies
jagannalla
Partner - Specialist III
Partner - Specialist III
Author

Then y it is not working for table box..y it is working with "," format

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

    If you check the both statement.

   

    obj.Export "MyQvd12.qvd",";"

    obj.ExportEx "C:\test.qvd", 4

    When we use ExportEx we need to specify the format, but when we use Export we need to specify the seperator.

Regards,

Kaushik Solanki 

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
jagannalla
Partner - Specialist III
Partner - Specialist III
Author

Ok kaushik once again thanks a lot for your breif description. Can you please check this Thread