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: 
Not applicable

Send to CSV with today's date variable

Hi All,

I need to send my staright table everytime after reloading to CSV file with today date.

EG: Today----> MyTableData_20/08/2013

       Tomo.----->MyTableData_21/08/2013

So i am done with send to CSV but facing problem to set variables for data.

  //***********************************************************************************************************************************//

Sub X
v=ActiveDocument.Evaluate("=date(Today(),'DD/MM/YYYY')")
ActiveDocument.Variables("Vdate").SetContent v,true

End Sub

Sub CSV
vFile=ActiveDocument.Variables("Vdate").GetContent.String
set sObject=ActiveDocument

set b=sObject.GetSheetObject("CH01")

b.Export "F:\QlikView\Test\MyTableData_"&vFile&".csv",";"
End Sub

  //***********************************************************************************************************************************//

the above query i not help to done this.

kindly help me to sort out this issue

Thanks

1 Reply
Not applicable
Author

Any Idea???