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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

CSV file with "comma seperator"

  hi all,

my macro query is given below

Sub CSV
set sObject=ActiveDocument
set b=sObject.GetSheetObject("CH02")

b.Export "D:\Qlikview\filename.csv",";"

End Sub

this query send my CSV file with ";" delimter but i want it in "," delimiter.

IF I CHANGED MY QUERY LIK THIS

Sub CSV
set sObject=ActiveDocument
set b=sObject.GetSheetObject("CH02")

b.Export "D:\Qlikview\filename.csv",","

End Sub 

then my output looks like excel no delimiters.

How i will get comma delimiter for this any idea?

thx

1 Reply
swuehl
MVP
MVP

b.Export "D:\Qlikview\filename.csv",","

works for me. I do get a comma separator.