topic Export to TXT in QlikView

Export to TXT

Sat, 24 Jul 2010 18:59:50 GMT

how to export a table to a file .txt and eliminate some columns that are not necessary
? for example , i have a pivot table with 3 dimensions and 7 expressions , but I only need to export 2 dimensions to create a new interface with another system . I am using the code below, but have exported all dimensions and expressions, is there a way to eliminate one dimension ?

SUB Export_GKO
VarDir = "c:"
rem VarDir = "c:\HORIMETROS"
msgbox "Preparing Interface.",VbOkonly,"GKO:"
Set olTabela = ActiveDocument.Sheets("GKO SAÍDA").SheetObjects("GKO_INTERFACE_SAIDA")
olTabela.Export VarDir & "FRDNE.txt", "#"
rem ActiveDocument.Reload
End Sub

Export to TXT

Oleg_Troyansky — Sat, 24 Jul 2010 19:22:30 GMT

The easiest way is to have a hidden Pivot Table with less dimensions and less expressions and use that for the export. What you exporting doesn't have the be the same object as the one that the user will see...

Export to TXT

hectorgarcia — Sun, 25 Jul 2010 03:10:52 GMT

if you are in qv9 you can do that in the script with store command. it is too powerful to this kind of tasks that generates info for other systems.

Hector

Export to TXT

surender_mehta — Sun, 25 Jul 2010 06:23:27 GMT

Creating another chart with less dimension and expression as required to export , set its layout below then the one sould be visible on the screen, call it via actions when exporting

Export to TXT

Sun, 01 Aug 2010 21:17:02 GMT

I appreciate all feedbacks but in my case i can´t delete dimensions because will affect directly the logic envolved in the chart. I ´m studying other possibilites. best regards

Export to TXT

llauses243 — Sun, 01 Aug 2010 23:19:16 GMT

Hi all,

Napoleon: Divide for win

popular phrase: Clone for adapt, no touch if func ¡¡

explain: clone your object and to prepare for export