topic Re: How can i export data into .csv format..? in QlikView

How can i export data into .csv format..?

Thu, 09 Jan 2014 05:28:36 GMT

Hi..

Please help me out...

Thank

RMB

Re: How can i export data into .csv format..?

Thu, 09 Jan 2014 05:33:49 GMT

Hi Mohan babu

Try This Macro for export your data into .csv format

Add a Button to trigger the Macro.

First you have to Set Variable to pass to the macro as it is not allowed to pass variables in the macro call. (vMCont and vMTab)

vMCont = container Object ID

vMTab = See Container - General - Label for Selected Item

Run macro = SetTabInContainer

Paste following code in to the macro editor

Sub SetTabInContainer

Set Container = ActiveDocument.Variables("vMCont")
Set Tab = ActiveDocument.Variables("vMTab")
Call InteranlSetTabInContainer(Container.GetContent.string,Tab.GetContent.string)

end sub

Sub InteranlSetTabInContainer (Container, Cname)

NewIndex = 0

Set ContainerObj = ActiveDocument.GetSheetObject(Container)
set ContProp=ContainerObj.GetProperties

for i = 0 to ContProp.ContainedObjects.Count - 1

if ContProp.ContainedObjects.Item(i).Text.v = Cname then
NewIndex = i
End IF

next

ContProp.SingleObjectActiveIndex = NewIndex
ContainerObj.SetProperties ContProp

end Sub

Re: How can i export data into .csv format..?

Thu, 09 Jan 2014 05:35:53 GMT

Right Click---> Export--> Save As (CSV) (Right click on the Chart Object)

Hope it helps..

Selva

Re: How can i export data into .csv format..?

Thu, 09 Jan 2014 05:43:10 GMT

Hi Mohan,

Simple default functionality of qlikview you can use. Right Click on Table go to Export Option then it will ask where to save there choose CSV from the Save As Type and save.

Re: How can i export data into .csv format..?

Thu, 09 Jan 2014 05:43:45 GMT

Thanks Guys..

Re: How can i export data into .csv format..?

Thu, 09 Jan 2014 05:45:27 GMT

Welcome. Check on the Correct Answer. it helps others.

Re: How can i export data into .csv format..?

Thu, 09 Jan 2014 06:01:11 GMT

Close this thread by marking correct answer

Re: How can i export data into .csv format..?

Anonymous — Thu, 09 Jan 2014 07:42:09 GMT

Hi,

If you want to store a complete table into a .csv during a reload you can use the STORE function in the script.

STORE mytable into mytable.txt (txt);

This will create a comma separated txt file.